Skip to main content



Create a Search From an Answer Saved as a Worksheet


Explains what the feature is or what its benefits are to the user or customer.


After creating an answer from a worksheet (also called an aggregated worksheet) and linking it to related data, you're ready to create your search. You can save the new search as a worksheet too, so that you can search it directly and share it with other people.

To do a search on the aggregated worksheet along with any data sources you linked:
  1. Click the search icon, and select Data Source. Choose your linked sources.

    Select sources

  2. Do a search using columns from the linked sources, including any aggregations you created.
  3. 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.
  4. 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.
  5. Click the Actions icon from the upper right side of the screen, and select Create Worksheet.


    The Create Worksheet icon

  6. Choose both views using Choose Sources.
  7. You may need to rename some columns appropriately for searching.
  8. Share the worksheet with the appropriate users and groups.
  • Was this article helpful?