After creating a worksheet from a search (also called an aggregated worksheet) and linking it to related data, you’re ready to create your new search. To do a search on the aggregated worksheet, along with any data sources you linked:
Click the search icon, and select Data Source. Choose your linked sources.
- Do a search using columns from the linked sources, including any aggregations you created.
- Test the result, to make sure it’s what you expect. If your search shows no data found or doesn’t look right to you, it is possible that one of the links between your sources was made on the incorrect column. Check the relationships you created and try linking using a different column, to see if that gives the expected search results.
- Once you have the expected answer, you can create a worksheet to make it easier for you and other people to use. To do this, click the DATA icon.
- Click the Actions icon from the upper right side of the screen
Select Create worksheet.
- Choose both views using Choose Sources.
- You may need to rename some columns appropriately for searching.
- Share the worksheet with the appropriate users and groups.