A workbook is where you build, inspect, and refine analysis in Insights, with direct control over the fields, filters, calculations, and results behind your work. Each workbook contains one or more tabs (queries). Every tab is based on one Insights Topic, and a workbook can be the finished analysis itself or the editable evidence behind a dashboard.
For more information on Topics, please refer to our Insights Topics Overview.
Note: tabs can be renamed and rearranged for better organization.
š¾ Saving a Workbook
Workbooks can optionally be named and saved. When a workbook is saved, it appears alongside other dashboards and workbooks in the content system.
If a workbook is not saved, you can still return to that analysis by searching for it in Recent. Recent logs all of your activity, whether on saved or unsaved workbooks.
š Workbook Modes (Viewing vs. Editing)
A workbook can be in either View or Edit mode.
View Mode: You are looking at the latest saved version of the workbook.
Edit Mode: You are changing the workbook, and changes will auto-save as you go. Changes made in edit mode will also impact the dashboard that is attached to the workbook.
You can see a history of all changes made by you or others by opening up the Version History panel and optionally restore a previous version. Note that only changes to the workbook are currently shown.
š Exploring a Workbook
Sometimes you may want to explore or iterate on an analysis without impacting the saved version. From View Mode, you can start interacting with the workbook to jump into an exploration.
While exploring, changes are not saved, and you can exit the exploration to return to the latest version of the workbook.
To save your exploration, select Save from the file menu. This will add all current changes into the saved workbook.
To save changes to a new workbook, select Save Asā¦.
Note: When you make any changes to the workbook, the changes will also be reflected on the dashboard associated with the workbook.
š§© Duplicating Workbook Tabs / Dashboard Tiles
Workbook tabs (queries) can be duplicated inside workbooks or moved to new or existing workbooks.
Copy Tab to New Workbook
Right-click on the tab and select Copy to new workbook. This will create a new workbook and import the tab. If the tab is connected with another tab (for instance, uses a lookup function), both tabs will be copied.
Copy Tab to Existing Workbook
Right-click on the tab and select Copy to existing workbook....
Copy the tab ID.
In the workbook you want to copy into (must be in the workbook view, not dashboard), select Import from the file menu and paste in the tab ID.
š¤ Workbook Agent & Formula Helper
The Workbook Agent enables you to ask questions about your data using natural language. For example, you might ask it, "How much revenue do I have on the books for this month?" The Workbook Agent then attempts to answer this question by generating a query and running it within the workbook.
Using the Workbook Agent
There are two ways to leverage this feature:
From the Results Tab: In the workbook, the AI Formula Helper will help you write a formula and add the results to the table.
You can interact with the formula generated just like any other formula (e.g., edit, rename).
Insights Workbook Agent:
Access the Workbook Agent by selecting the three stars on the left navigation bar.
A panel will open next to the field picker with tips on how to use the feature and a text box to ask your first question.
Note: the query can only be based on fields within the Topic you have selected
Note: The Workbook Agent does not respond with a text answer. It generates a query that appears on the right-hand side (selected fields, filters, and results), built from the fields in the Topic you have selected. Review what it built before you rely on it. If your question needs data from another Topic, add another tab or ask in Chat.
For more information on Topics, please refer to our Insights Topics Overview.
Iterative Chat Interface
The chat interface is iterative, allowing you to refine your queries:
Example:
You: "How much revenue do I have on the books for this month?"
Workbook Agent's Answer: [Displays query and results]
You: "Break this down by department."
Workbook Agent's Next Answer: [Updates query and results]
Help us improve the experience by rating the results. š
Note: If you close the Workbook Agent, the text history is deleted.
By utilizing Insights' robust features, you can seamlessly analyze and share data, leveraging both manual queries built with Topics and AI-assisted insights to drive informed decision-making.