Pinboards act like live dashboards. They are collections of your related Answers, in the form of charts and tables, and your headline metrics.
You can pin charts, tables, and headlines to any Pinboard which you created, and those that have been shared with you with the Edit privilege. When you create a Pinboard, you can share it with other people with either the View or Edit privilege. Pinboards are interactive, allowing you to perform actions like drilling down on Answers, filtering, excluding values, and exploring Answers or headlines.
This is an example of a Pinboard you might create or view, as a member of a retailer’s Sales department:
Notice that you can explore any visualization, follow any headline, or perform a number of other actions using the more options menu at the top right corner of a visualization .
You can filter a Pinboard to only see the relevant data. Click the More icon at the top right corner of the Pinboard, next to the Follow and Share buttons. Select Add filters. Note that you need access to the underlying data source to be able to filter a Pinboard.
Choose a column to filter on, and select values to include or exclude.
See Pinboard filters for more information.
Getting to insights
You can leverage Pinboards to gain insights into your data in several ways. Answer Explorer, ThoughtSpot’s AI-guided exploration of Answers and headline metrics within Pinboards, provides you with valuable suggestions on how to explore and understand your data. The feature suggests ways to answer questions that are relevant to many other users, and it takes into account your own ThoughtSpot history. Use Answer Explorer to filter an Answer or headline, run comparisons, replace items in an Answer, or add additional elements to an Answer.
Pinboards always have the most current data. If you follow a Pinboard or a pinned headline metric, you can schedule regular updates on that Pinboard or pinned headline, and track its changes.
You can also drill down on any Answer in a Pinboard. See Drilling down.
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 from within the Answer Explorer view in a Pinboard. This allows you to use the back button to go back one step at a time, and to see the Answer fill your screen.
Use the Present feature to present a Pinboard as a live slideshow with the latest data. You can answer questions instantly during your presentation by editing an Answer, drilling down, filtering a visualization, or using Answer Explorer.
To present a Pinboard, click the More icon at the top right corner of the Pinboard, and select Present.
Edit an Answer during a presentation by clicking the edit icon that appears in the upper right corner when you move your mouse.
You can download a Pinboard as a PDF, or as a scriptable file for migration to another environment.
To download a Pinboard, click the More icon at the top right corner of the Pinboard, and select Download as PDF. You can download the whole Pinboard, or just certain visualizations.
To export a scriptable file, click the More icon at the top right corner of the Pinboard, and select Export as .tsl. You can export Pinboard and the underlying data source, or Worksheet, or just the Pinboard.
Sharing Pinboards and Answers
You can share Pinboards and Answers with other ThoughtSpot users and groups, and send them a notification email. See the following video for details.
See Overview of Sharing.
Answers are saved search results. When you search on your data, your results appear in the form of a table or chart, depending on your search. There are many different types of charts. ThoughtSpot picks the chart type that best fits your search, but you can choose another chart type if you like. When you’re done customizing a search result, you can save it as an Answer, and pin it to a Pinboard. The Answer always contains the latest data.
You can easily change a saved or pinned Answer by customizing it to suit your needs.
- Change between table and chart representation by toggling between the table and chart elements.
- Change chart type by selecting a different visual type from the chart catalog.
Configure the chart by clicking the gear element: .
- Add drag-and-drop chips automatically when adding new elements in search bar. These appear on the chart as “Not visualized”, and you can move them into the axis area to visualize.
- Improve number formatting for data labels on the chart marks (bars, bubbles, lines), and on the axes. Can use numbers, percentages, currencies, and specified units, “as is” (auto mode), or change to millions, trillions, and billions (K, M, B). Can easily specify the number of decimal places.
- Independent control of each measure in a chart helps you reduce noise by applying labels only where you need it.
- Simple time bucketing lets you change granularity of time series.
- Intuitive color configuration enables you to quickly change color on the element or in the legend.
- Column renaming for pivot tables and regular chart tables
- Wrapping and clipping of text in a table.