Sheets on Dashboards
With 2022R2, we continue to improve sheets on dashboards, enabling more flexibility with performance and options to view sheets.
Optimize Sheets on Dashboards
Release: 2022-09-10
We deliver a new Optimize Sheet option in Data Settings when you edit or create a sheet on dashboards. This enables you to use a new version of sheets on dashboards that improves load times.
When you enable the new option, you can:
- Only view data on the sheet. To add or edit data, you can maximize the sheet.
- Search and filter sheet data. All other toolbar options are only available in maximize view.
- Select dimension pickers on cube sheets. We grey out dimension pickers that match perspective context filters.
- Refresh all sheets when you change perspective filters and automatically save your changes.
- Persist views between the default and maximize view.
Optimize Sheets on Dashboards
Release: 2022-09-10
You can now enable the Optimize Sheets on Dashboards feature using a new Optimize Sheets toggle for Dashboards check box in Visual Preferences.
Select Cells for Simple Calculations
Release: 2022-09-10
We now provide simple calculations when you select more than 1 cell to match the experience in standalone sheets. You can display the calculations for:
- Average
- Count
- Count Nums
- Max
- Min
- Sum
Select Cells for Simple Calculations
Release: 2022-10-14
We now provide simple calculations when you select more than 1 cell in sheets on dashboards when
Optimize Sheet
is enabled. You can display the calculations for:
- Average
- Count
- Count Nums
- Max
- Min
- Sum