You can save an answer as a worksheet, otherwise known as an aggregated worksheet, in order to perform a search on top of another search. This allows you to produce complex reports, such as those that would normally require nested SQL queries.
Our first example involves creating an aggregated worksheet with a default filter.
Say you want to create a worksheet that only shows data for a particular US state. In your search, enter “customer state = texas”. Then click Actions, and select Save as worksheet. Give your worksheet a name, then click Save to create your worksheet.
Now you have a worksheet that only contains data that pertains to Texas. You can share this worksheet with others to search across. Another popular example of this concept includes creating a worksheet with only active employee data.
Our second example involves joining two aggregated worksheets.
Say you want to plot the revenue of the top 5 states over time. Search for revenue, store state, and top 5. Save this answer as an aggregated worksheet called Top 5 States. Then start another search with the tokens revenue, store state, and date. Save this answer as an aggregated worksheet called Total Monthly Purchases.
Now you want join these two worksheets. Navigate to the Data tab and make a relationship between the two worksheets, involving store state.
To start a new search, select your two aggregated worksheets as data sources, selecting the appropriate columns: store state from Top 5 States, and date and total sales from Total Monthly Purchases. You will only see data for California, Colorado, Illinois, Indiana, and Texas.