Explains what the feature is or what its benefits are to the user or customer.
Most searches in ThoughtSpot are easy to do without training. But there are some advanced search features that are very powerful. This section explains how to use the more advanced features.
Some of the more advanced features are:
Aggregated worksheets allow you to save a search as a worksheet, optionally link it to other data sources, and do another search on top of it. This workflow allows you to produce some complex reports, like those that would require nested SQL queries in some other tools.
Formulas in searches brings the power of formulas to regular searches, instead of requiring that you first create a worksheet. This allows any user to do mathematical operations, use if...then...else logic, check for empty (null) values, bucket their data, etc.
Grouping formulas are called pinned measures or level-based measures in some other tools. They provide the ability to aggregate a numeric value (measure) at a specific attribute level.
About Worksheets from Answers
If you want to do an advanced search that involves what is essentially a search on top of another search, try saving an answer as a worksheet. Then you can use the saved worksheet as a data source for a new search.
About Formulas in Searches
To provide richer insights, you can add a formula to your search. The Formula Builder includes many types of operators, such as logical (if, then, else), math, date, and text string functions.
About Grouping Formulas
What if you want to aggregate a value by a specific attribute (for example, show revenue by product)? This is known as a grouped aggregation, but some people call it a pinned measure or level-based measure.
About Bulk Filters
If you have a large worksheet or table with thousands or millions of rows, you may want to create bulk filters. You can paste in a list of filter values, without having to click the box next to each value in the filter selector.
About Pinboard Filters
Filters, including bulk filters, can be applied to pinboards just as with tables. These kinds of filters apply to an entire pinboard, making it easy to see only the data that you are interested in across the tables and charts within a pinboard.