In ThoughtSpot, you can start changing all axes options by clicking on the axis, directly in the chart.

To change axis, you can click the axis itself.

Here, we demonstrate the various options for axis configuration using a visualization “Sales by Department”

Change axis

This opens the detail axis customization menu in the chart.

Change axis detail

You can make the following changes to the axis:

Change the axis aggregate

To change the axis aggregate, click the Aggregate option in the axis menu, and select an alternative from the list of options.

Depending on the type of data type and other settings, the aggregation options include Total, Avg, Min, Max, Total Count, Unique Count, Std Deviation, and Variance.

Change axis aggregate

Add, Change, and Remove Filters

To manage the filters applied to the axis (in this example, Total Sales), follow these steps:

  1. Click the Filters option in the axis menu.

Change axis filter

  1. In the window modal, click + add a condition.

    Add a condition to axis

  2. Select the comparison option.

    Here, the options include is greater than, is greater than or equal to, is less than, is less than or equal to, is between, is in, and is not in.

    In this example, select is greater than or equal to.

    Set filter comparison operation

  3. Set the relevant numerical limits.

    Here, enter the maximum of 1000000.

    Set filter numerical limit

    Note that if you select the is between comparison operator, you must set two limits: minimum and maximum. Similarly, is in and is not in operators require a list of values separated by “;”.

  4. To add another filter condition, click +add another.

    Add another filter condition

  5. To remove a filter condition, click the delete icon (x) next to its definition.

    Remove filter condition

  6. Click Done.

    Complete filter on axis

Here, you can see differences between the original chart and the one with the filter applied: Three (3) of the departments had sales under $1,000,000, and they don’t appear on the newer chart.

Chart with filter applied

To remove a filter from the chart, click the x icon on the filter tile.

Remove filter from a chart

Apply conditional formatting

To apply conditional formatting to the axis (in this example, Total Sales), follow these steps:

  1. Click the Conditional formatting option in the axis menu.

    Add conditional formatting

  2. The Conditional formatting window modal appears.

    Conditional formatting interface

  3. In the window modal, click + add formatting.

    Add a format

  4. Select the conditional range.

    The text area on the left specifies the lower limit of the condition, so the condition applies to all values that are greater or equal to it. And the text area on the right specifies the upper limit of the condition, so the condition applies to all lower values.

    • To show show values with a lower limit, enter a value in the left text box.

    • To show values with an upper limit, enter a value in the right text box.

    • To show values in a specified range, enter the appropriate values in both text boxes.

    Here, we apply conditional formatting to values between 5,500,000 and 8,000,000.

    Add conditional format range

  5. To specify a different color of the conditional format, select the new color from the color selector.

    This option draws upper and lower limit lines on the chart, and colors the chart elements that meet the conditional requirements.

    Change conditional format color

    Alternatively, you can place a range band on the chart. Select the Fill chart option.

    Add conditional format band

  6. To add another condition, click +add formatting.

    Add another conditional format

  7. To remove a defined conditional format, click the delete icon (x) next to its definition.

    Remove conditional format

  8. Click Done.

    Complete conditional format

Here, you can see a chart that highlights elements with conditional formatting on some elements. You can also see how the same chart appears with a background chart band.

Conditional formatting applied, two options

Change the Sort

To change the sorting of a measurement on an axis, click the Sort option in the axis menu, and select an alternative from the list of options: Ascending or Descending.

Change axis sort

Here, you can compare the original chart that was not sorted on the Total Sales axis with the chart that uses descending sort.

Compare unsorted chart and chart sorted in Descending order

Change the Postion of the axis

It is generally easier to interpret a chart if axes that use the same units of measurement or scale appear on the same side of the chart. In our example, we can best visualize Item Cost and Item Price on the same side of chart.

To change the position of an axis, select the Position option in the axis menu, and then select an alternative from the list of options: Left or Right.

Here, we move the Item Price axis from the right side of the chart to the left side.

Change axis position

You can compare the original chart with the one where the Total Sales axis is on the right, while Item Cost and Item Price both appear on the left.

Compare charts with different position assignments

Change the Grouping

When two axis use the same unit of measure and a similar scale, we can group them together.

To change the grouping on an axis, click the Group option in the axis menu, and select an alternative from the list of options, which are the measurements on the other axes.

Here, we change the Item Price axis by grouping it with Item Cost.

Group two axes

Compare the original chart with one that groups Item Price and Item Cost as Item Price & Item Cost. The chart looks cleaner, and clearly communicates the distinct information on each of the two measurements.

Compare ungrouped chart and chart that groups similar measures

Notice that the Customize menu shows a linkage between the two grouped axes.

Grouped axes

Rename an axis

You can always rename an axis for clarity, brevity, format, and so on.

In our example, it makes sense to rename the axis created from grouping as Item Price & Item Cost to something shorter, like Item Price and Cost.

To rename an axis, select the Rename option in the axis menu, type the new name, and either click out or hit Enter/Return on your keyboard.

Rename axis