Change result display options

Your search results, or answers, have various display options. You can change the visualization used to display your results, their sort order, how ThoughtSpot groups the data, and what data ThoughtSpot includes.

Change the view

You can change the view of your answer so it appears as either a table or a chart. To change the view of your answer:

  1. View your answer.

  2. Toggle between either a table or a chart type.

    Select table or chart

When you display your data as a chart, ThoughtSpot automatically selects the type of chart that works best for your data. If you want to use another type, click the change visualization icon Change visualization icon image and select the type of chart you want. Refer to Understand charts.

Sort your search

Sorting your search allows you to order your answer, making it easier to read. To sort your search:

  • If you are in the data (table) view, select the column header you would like to sort on.

    By default, sorting applies in descending order. For example, if the column has numerical values, it would start at the highest number and decrease. Click the column header again to sort in ascending order.

    Hold shift and select another column to add a secondary sort. You can even add tertiary sorting and so on by continuing to use this trick.
  • If you are in the chart view, click the axis label of your chart that you would like to sort and select Sort. You can choose to sort in ascending or descending order.

Hidden sort

You can also sort by a measure that you do not want to include in the chart. For example, if you search for cost store name sort by gross profit margin, you can move gross profit margin to the Not visualized section from the Edit chart Edit chart configuration icon image panel. ThoughtSpot sorts the chart by gross profit margin, but gross profit margin does not appear in the chart. This is also known as a hidden sort.

Hidden sort example
You cannot perform a hidden sort on an attribute or date column.

Change the date bucketing (grouping)

You can change the date bucketing on tables and charts for columns with date values. Bucketing is a method for grouping a column in your data. To bucket your data in a table view, select the More menu icon More options menu icon that appears when you hover over a column name on a table.

You can specify date bucketing at many granularities, from detailed (to the minute or second) to yearly, depending on your data. You can also specify bucketing based on the position of a bucket relative to another, larger bucket. For example, you can group data by month of quarter, or week of month.

Choose a date bucket on a table

To bucket your data in a chart view, select the dropdown icon Dropdown icon image that appears when you hover near the axis labels on a chart.

Choose a date bucket on a chart

ThoughtSpot chooses a default date bucket for you when you search. This default takes the entire search result into account. For example, if your search includes last month, dates are bucketed daily instead of monthly.

Exclude and include row values

You can include or exclude row values from your answer.

To exclude or include row values:

  1. Right-click the visualization or table cell of interest.

  2. Select Exclude "value" or Only Include "value" if available.

    Exclude or include a value

Undo, redo, and reset buttons

As you work with searches and answers, you may want to undo or redo an action. Use the in-product undo, redo, and reset buttons to reset or go back or forward 1 step each time you make a change in a search, saved answer, or Liveboard visualization (for example, when you add a new column to the search, drill down, or sort) These buttons appear to the right of the search bar in a search or saved answer. Note that the reset button is only available for saved answers; it resets the answer to its last saved state.

Undo

If you do not have the new answer experience on, you can use the browser back button. The browser back button is not as precise, and does not work on saved answers.