Show underlying data

You can see the most granular details of a given result set, that is, it shows the un-aggregated view. This feature lets you understand what an Answer consists of. For example, if you search for customer region revenue, the Answer shows the aggregate revenue value for each customer region. Then, you can right-click any row and then select Show underlying data, to see each value which constitutes revenue for any given region.

Only the first 1,000 rows appear when viewing the underlying data. You can even download the results shown when you choose Show underlying data from a chart. The download file limit is a million rows.

ThoughtSpot does not support showing underlying data for searches based on schemas with chasm or fan traps, or for columns based on aggregate formulas.

To show underlying data:

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

  2. Select Show underlying data.

    Select Show underlying data from the menu that appears

    A new window opens that displays a summary and the underlying data.

  3. Optionally, choose to + Add columns to add additional data.

    If you select + Add columns
  4. Select Confirm Changes.

  5. Select Download CSV in the lower-left corner to download a CSV file of the data.

    Select Download CSV in the lower left corner