Drill down into your data

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.

Starting in May 2022, ThoughtSpot rebranded pinboards as Liveboards. For backward compatibility, we currently support internal processes and external methods that use the older naming convention.

You can drill down in both tables and chart visualizations, on both standalone Answers and on Answers within Liveboards. When you drill down on Answers within Liveboards, you can either drill down directly, or drill down using the Answer Explorer view. Answer Explorer provides a flexible, AI-guided exploration of an Answer within a Liveboard.

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 chart object

  3. A list of attributes appears. If you are on the new answer experience, you can drill down by both measures and attributes. On the classic answer experience, you can only drill down by attributes. 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

    To go back or forward one step at a time, use the in-product back button to the right of the search bar. If the new answer experience is off in your environment, use your internet browser’s back button.

    Your browser’s back button only goes back one step on unsaved answers, and does not work if you have the new answer experience on. If you are working with a saved answer, clicking your browser’s back button prompts you to save your unsaved changes, and does not take you back to the previous step in your Drill down.

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

Drill down within a Liveboard

When you drill down on an Answer within a Liveboard, 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 reset icon. The reset icon is a blue icon at the lower right corner of the Answer.

Reset your visualization

Drill down with Answer Explorer

You can also drill down using the Answer Explorer feature. Answer Explorer provides AI-guided exploration of an answer within a Liveboard. When you drill down normally, you cannot go back one step at a time to see an earlier version of your visualization. You have to delete filters from the search bar, or start your search again. If you drill down with Answer Explorer, you can use the go back one step feature.

As you drill down on an answer using Answer Explorer, use the back arrow icon arrow left 10px to go back one step at a time. Click the reset icon icon reset 10px to go back to the original 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 More menu icon more options menu icon.

  2. Select Copy and edit or Make a copy, depending on your answer experience.

  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 icon share 10px. Otherwise, the Answer returns to its original state when you exit the page.

Share your data

If you own a Liveboard or answer, you can drill down to the data beneath. Users you share a Liveboard 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 Liveboard or answer’s underlying data source, you cannot drill down. See overview of sharing to share your answers, Liveboards, or data.


Was this page helpful?