Understanding Analyze - Spotlight for Google Sheets
- 1 Minute to read
- Print
- DarkLight
- PDF
Understanding Analyze - Spotlight for Google Sheets
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The Analyze task allows you to perform actions by selecting a model and an associated view, refreshing the data or zooming in and out of the model. You can also keep or remove certain aspects of the view and pivot the dimensions as required.
When you select Analyze, the available models will be listed with ad-hoc analysis and predefined views.
Note:
The user security defined on SpotlightXL or Spotlight Web would be carried forward to Google Sheets. Hence you must have access to both.
This page will contain a list of models and views in the below pattern:
- Analytical Models (listed alphabetically), followed by their view
- ESM Models (listed alphabetically, followed by their viewNote:A default view will be created if there is no predefined view.
- FavoritesNote:This displays a list of views selected as favorites in SpotlightXL or Spotlight Web.
- RecentNote:This displays the recent view opened by you.
.png)
Default Views (Ad-hoc analysis)
A default layout is created with all dimensions listed for each model, which can be used for ad-hoc analysis.
.png)
Notes:
- The Default views cannot be deleted, renamed, or moved as it is available in read-only mode.
- The menu bar for Analyze task is non-actionable until you select or double-click any view of a Model.
.png)
- To create an ad-hoc (Default) view, navigate to Analyze and select any model > Default.
.png)
.png)
.png)
Was this article helpful?