Changing charts
You can adjust all aspects of ThoughtSpot charts: color, legends, axis, number format, and many more.
To make changes to the chart configuration, select the gear icon in the upper-right corner of the visualization.
This opens the Edit chart panel for the chart, which contains the Customize and Settings menus. Using this menu, you can drag and drop measure and attribute chips to or from an axis. Click on any measure or attribute chip that has a more icon (>) to customize it. In the following image, Total Sales is customizable.
You can edit some of the elements of the chart directly, by clicking on them. For example, you can change the appearance of a chart axis by clicking it and making selections in the available options.
Chart configuration options
Through the Customize menu, you can perform a number of customizations:
-
Drag and drop measures and attributes to or from an axis
-
Set up your chart by dragging and dropping the measures and attributes in your search onto the appropriate axis.
If you want a column to be part of your search and show up in the table view, but you do not want to include it in your chart, you can drag it to the ‘Not Visualized’ section. You can also use this functionality to perform a hidden sort, by moving the measure column you want to sort by to the ‘Not Visualized’ section.
-
-
Number formatting for all data labels
-
Category (Number, Percentage, Currency)
-
Units (K, M, B)
-
Decimals
-
Independent control for each measure on the chart
-
-
-
Grouping and ungrouping of axes
-
Axis renaming
-
Changing the position of an axis
-
Changing the axis minimum and maximum values
-
Changing number formatting on the axis
-
-
Change position of the legend
-
When you create a visualization, you have the option to change the legend position, or hide the legend entirely. Select the chart configuration icon
and select Settings. You can choose to position Legend on right, Legend on left, Legend on top, or Legend on bottom. -
Click the Show legend toggle to hide the legend.
-
Through the Edit chart menu, you can perform a number of customizations:
- Drag and drop measures and attributes to or from an axis
-
Set up your chart by dragging and dropping the measures and attributes in your search onto the appropriate axis.
If you want a column to be part of your search and show up in the table view, but you do not want to include it in your chart, you can drag it to the ‘Not Visualized’ section. You can also use this functionality to perform a hidden sort, by moving the measure column you want to sort by to the ‘Not Visualized’ section.
- Number formatting for all data labels
-
-
Category (Number, Percentage, Currency)
-
Units (K, M, B)
-
Decimals
-
Independent control for each measure on the chart
-
- Change axis options
-
-
Grouping and ungrouping of axes
-
Axis renaming
-
Changing the position of an axis
-
Changing the axis minimum and maximum values
-
Changing number formatting on the axis.
-
- Change chart colors
-
Change the color chips for a column or a value. You can set custom colors for bars, lines, areas, bubbles, maps, and other chart types. You can also "slice" with color, set legends on charts, and enable conditional formatting in tables.
- Results that are tables
-
-
No line limit for headers in wrap mode
- Reorder labels on the axis or legend
-
When there are multiple columns on the x- or y-axis or legend of a chart, you can change their position in the chart by using the chart configuration icon.
- Set the y-axis range
-
Manually set the y-axis range by using the chart configuration icon.
- Hide and show values
-
Change the visibility on the chart using the legend.
- Show data labels
-
Configure charts to show the y-axis data values.
- Show data markers
-
On line charts, show data markers.
- Specify time bucketing
-
You can easily change the date bucketing on a chart or table, from weekly to month of quarter, for example.
- Add regression lines
-
You can add a regression line to your chart.
- Display gridlines
-
Add X and Y gridlines to your chart.
- Disable automatic selection of chart type
-
Turn off the 'automatically select my chart' option if you want a specific chart type to persist throughout a search.
- Zoom into a chart
-
You can zoom into your chart by selecting an area with your mouse.
