Explains what the feature is or what its benefits are to the user or customer.
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.
Introduction to worksheets from answers
Although a worksheet created from an answer is effectively the same as any worksheet, we'll call it an "aggregated worksheet" here to avoid confusion. When you do a search on a data source, ThoughtSpot is only able to aggregate one column by one other column. Because of this, you may come across searches you can't do in one pass, because they are essentially nested queries. But you can create the equivalent of nested queries using an aggregated worksheet, which is essentially an answer that you save as a worksheet. Then you can use that worksheet just like any other data source. You can even link it to other sources by defining a relationship. When you save an answer as a worksheet, and then use it as a source in a new search, it is similar to doing a nested query in SQL, only much easier to create.
Aggregated worksheet workflow
- Create the first search, and save it as an aggregated worksheet.
- Link your worksheet to any other data sources you'll need.
- Create a new search that includes your aggregated worksheet and the other sources you linked with it.
- You may want to create a new worksheet that includes these data sources. This will make it easy for users to search using the same group of aggregated worksheet and tables that you created.
Best practices for using aggregated worksheets
- Only users with administrative privileges are able to create aggregated worksheets and link them.
- You can't link an aggregated worksheet with a sharded table. If you do this and try to search on it, you will get an error.
- Joins are directional, meaning that the order of the objects being linked matters. The table/aggregated worksheet with the foreign key needs to occur in the first (left) position. The one with the primary key needs to go in the second (right) position.