Drill down into the Answers ThoughtSpot delivers to gain deeper insights into the many layers of your data.
Estimated reading time: 3 minutes

When you drill down, you can see more information about the data within your search. You can drill down into a datapoint to get a finer grained view of that datapoint and the data behind it. Move easily from a general view of your information to a more specific representation of the data behind a datapoint at a click. For example, in a revenue by department search, you may notice that your clothing department has the highest revenue. You can drill down on clothing by product name to find out which products contribute to those high sales. There is no limit to how deep you can drill down.

You can drill down in both tables and chart visualizations, on both standalone Answers and on Answers within Pinboards.

Drill down on an Answer

  1. Right-click the chart object (such as a column on a bar chart, or a section of a pie chart) or data point of interest in your answer.

  2. Select Drill down.
    This limits the data you are exploring to that particular data point or chart object. Drill down from a data point Drill down from a chart object

  3. A list of dimensions appears. You can only drill down on dimensions, not on measures. Click any of the options to gain deeper insight into your data.

    Drill down dimensions

    For example, if you choose to drill down on dairy by product full name, the following chart appears, showing dairy sales by product:

    Dairy sales by diet type

    Use your internet browser’s back button to go back one step at a time.

    You can continue to drill down in the data until you run out of relevant dimensions.

Drill down within a pinboard

When you drill down on an Answer within a pinboard, it works similarly to drilling down on the Answer itself. You cannot go back one step at a time, but you can reset the Answer when you finish drilling down. To return to the original answer, click the blue reset icon at the bottom right corner of the Answer.

Reset your Answer

Save and share your new answer

When you find a valuable insight using Drill down, you may want to save that Answer instead of trying to recreate it in the Search bar later.

  1. Click the ellipsis icon .
  2. Select copy and edit.
  3. Save your new Answer and continue working with it.
  4. Alternatively, select Download to download an image of your current visualization.

You can also share the Answer by clicking the sharing icon . Otherwise, the Answer returns to its original state when you exit the page.

Share your data

If you own a pinboard or answer, you can drill down to the data beneath. Users you share a pinboard or answer with can also drill down provided they also have access to the data on which the board was based. If you do not have access to a pinboard or answer’s underlying data source, you cannot drill down. See overview of sharing to share your answers, pinboards, or data.