Use sheets on dashboards to enter data without navigating away from your dashboard. Save your sheet to dynamically see changes on dependent charts and dashboards.
See Sheets on Dashboard Settings for setting options and toolbar descriptions.
Before You Begin
- Select Edit to put your dashboard in edit mode.
- On the left panel, select to choose a chart. Drag and drop Sheet to the design area.
- On the right panel, give the sheet a name in Appearance Settings . This only names the container for the sheet and does not change the sheet name.
- Select Data Settings , then select the sheet. All cube, modeled, and standard sheets that you have access to are available.
- Select Done .
Change the Display of Sheets on Dashboards
You can change the display of rows and columns for an individual sheet. You can create multiple sheets with different display configurations based on the same underlying sheet. Perspective context filters takes priority over sheet view and display settings.
To change the display for an individual sheet:
- From edit mode, select a sheet > Data Settings > Display Options.
Change the display of your rows and columns. To dynamically change sheets with different time ranges at the perspective level, select a relative Viewable Time Range (for example: Current Month).
Select OK to save.
Temporarily change Display Options for a sheet with Display Options . These display changes do not persist when you navigate away from the page, or make changes at the perspective level.
If you maximize your sheet, any view or display changes made in maximize view might not persist in the default view.
Edit Sheet Content
Once you add a sheet to a dashboard you can edit its content if:
- You have permissions to edit the sheet.
- You select the level the sheet belongs to in the dashboard perspective context.
- The dashboard is not in edit mode.
The type of edits you can make depend on the sheet type.
- Select the level this sheet belongs to in perspective context.
- Select inside the sheet to edit. You can use the sheet toolbar and any right-click context menus available.
- Select to update your sheet and dependent charts in the dashboard.
Change Cube Sheet Filters
The filters you would normally see in a cube sheet in a standalone sheet are view only in Dashboards default view until the sheet chart is viewed in maximize view.
To change cube sheet filters:
- Move your cursor over a sheet chart containing a cube sheet.
- Select Maximize View for the sheet.
- Edit the cube sheet dimension filters.
- Select X at the top right of the maximize view to return the sheet to its default view.
Perspective dimension filters override modified cube sheet dimension filters.
Sheet on Dashboards Example
Top Line Expense What-If Analysis
You might have an Expenses Top Line dashboard that list your top line expenses. You can add sheets on your dashboard to enter data and change driver numbers in your charts to see how different what-if scenarios impact your top line expenses.