/ Do Advanced Searches


Do Advanced Searches


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.