ThoughtSpot

ThoughtSpot uses unique terminologies that you will see referenced when using the software.

Answers are Charts, Tables, or other visualizations of your data.

Pinboards are dashboards that you can pin and unpin, rearrange, and resize your charts, tables, and other Answers.

Searching is how you start creating an answer. You search your data and save the result as an Answer.

Now that you understand these terms, you can continue reading to see how to Drill Down, use Interactive Labels, Download data, and Explore your data.

Each Answer (data visualization/graph) can be thought of as a starting point for your data. For instance, in the Ticket Totals Monthly answer (see table below), your starting point is the total number of unique tickets for your billing code for the months displayed on the graph.

If you want to see how many tickets of each ticket type were received in each month, you can drill down into that month by ticket type. To do so, follow these instructions:

1. Right-Click the month you want to drill down into
2. Select Drill down from the pop-up menu
3. Search for Ticket Type in the search box, and select Ticket Type from the results
4. The results are displayed.

At this point if you want to reset the graph to the initial view, click the blue circle with the arrow in the bottom of the right of the graph. You can also drill down further if you like by right clicking a ticket type value on the resulting chart, selecting Drill down again, and searching for and selecting the data item that you want to further investigate (for instance, Excavator Type).

Watch Drilling Down Video Explanation >

You can download any Answer that is a graph, chart, or visualization as an image (PNG). You can also download Answers that are tables, such as the Ticket Insights table on the Member Overview pinboard in Excel (XLSX), Acrobat (PDF), or Comma Separated Values (CSV) formats.

1. Move your mouse pointer to the answer
2. Click on the ellipsis (…) icon that pops up
3. For visualizations, select Download
4. For tables, select Download as CSV, Download as XLSX, or Download as PDF, depending on the format you need.

Watch Download Video Explanation >

Many of the visualizations in Thoughtspot have interactive labels. On pie charts, for instance, clicking on a label will slide out the pie piece that that label represents so you can see that slice better. For Bar or Column charts, clicking on a label can remove or add back in that labelled data item.

Pie Chart

1. Click on the label of the slice you would like highlighted
2. Click on the label again to have that slice slide back in
3. Alternatively, click on the label of another slice to have the original slice slide back in and then new slice slide out

Stacked Column

1. Click on the label to see that data item removed from the chart
2. Click on the label again to see it added back in

For charts like Emergency Notifications by Hour Last 30 Days, you can remove days from the chart by clicking them. For instance, if you click on Saturday and Sunday, you will see the chart show the emergency notifications by hour for only weekdays (Saturday and Sunday will not be reflected in the chart). To add them back in, click on those labels again.

Watch Interactive Labels Video Explanation >

Exploring is a useful tool to see different aspects of your data. For instance, you can look at the Ticket Totals Monthly and exclude emergency tickets or add in the Day Of Week. When exploring data, you can Filter, Add, Replace, and Compare.

To start exploring:

1. Move your mouse over the answer
2. Click the Explore button that pops up

Next, select the operation you’d like to do with the data:

Filter – exclude some subset of data from the Answer

1. Search for the data item you’d like to filter on and select it. For instance, Ticket Type.
2. Select a comparison (such as “equal” or “does not equal”)
3. Select or search for a value to filter
4. Click Apply to see the changes

Add – add additional data to the Answer

1. Click in the search box.
2. Search for the data item you want to add, such as Day of Week and select it. The results are shown immediately.

Replace – Replace one data item with another

1. Select the data item you want to replace, such as Monthly.
2. Select what you want to replace that with, such as Quarterly. The results are shown immediately.

Compare – Select a data item to compare, and then select two values of that data item to see them side by side.

1. Click in the search box and find the data item to compare (for instance, Ticket Type), and select it
2. Select a value of that data item, such as Normal
3. Select another value, such as Emergency
4. Click Compare
5. The visualization is updated to show the two values

Watch Exploring Data Video Explanation >