Drill down into your data

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

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 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 data point Drill down from a chart object

  3. A list of attributes and measures appears. You can drill down by both measures and attributes on the new answer experience. 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 blue reset icon icon drill down 20px at the bottom right corner of the Answer.

Reset your answer

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 within a Liveboard but not within Answer Explorer, 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, or on an answer or search that is not part of a Liveboard, 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.

If you want to go back one step at a time while drilling down, either drill down on an answer or search that is not part of a Liveboard, or add your answer to a Liveboard so you can use Answer Explorer.

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 icon icon more 10px.

  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 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.