Dashboards allow you to view and filter on multiple Looks or queries at once. If you have permission to edit dashboards, you can also add new tiles and new filters and adjust the dashboard loading settings.
- Opening and viewing a saved dashboard
- Editing dashboards
To learn how to save a Look to a new or existing dashboard, see Creating a new Look in Data Exploration.
Opening and viewing a saved dashboard
To view a dashboard, select an Explore, go to the icon, and select the name of the dashboard under Dashboards that you wish to open. Use the icons on the right to navigate between the Personal, Group and Shared folders.
You will see the different tiles and Looks that have been added to the dashboard.
You can click the three dots on any tile in the dashboard and select Explore from here to open the query in the Explore and drill down on the data. You can also select Download data to download the results from the query in your chosen format. Note that if a tile was created from queries merged from different Explores, you cannot download its results as an individual report. Instead, you should download the entire dashboard and select CSV as the format in order to download a zip folder with all the results of the dashboard tiles as CSV files. See Downloading content from a Look or Explore in Data Exploration for more information about the download options.
Hover over the icon to view the time zone for the tile.
The time that the dashboard was last updated will appear on the left. It indicates the last time all the tiles in the dashboard were refreshed at approximately the same time.
Click to load or reload the dashboard.
Any filters that have been applied to the dashboard will be displayed on the left. You can adjust the filters according to how you wish to view the data.
Use the button to hide the filters.
Click the three dots to review the available dashboard actions.
The following options are available:
- Edit dashboard: select this option to make changes to the dashboard.
- Download: select this option to download the dashboard as a PDF, or download the data from each tile as a CSV file.
- Reset filters: select this option to remove any changes that you made to the filters and set them back to the originally configured filters.
- Each tile's time zone: select this option to change the default time zone option (each tile's time zone). By default, the time zone of each tile will be displayed. You can change it so that one time zone is applied to all tiles. When one time zone is selected, the icon will not appear on tiles.
- Move to trash: select this option if you wish to delete this dashboard.
Select the folder icon to view your Looks and dashboards by folder.
After selecting Edit dashboard, you will be able to make changes to the filters and tiles of the dashboard.
You can edit the title of the dashboard.
To edit or delete a dashboard filter, click the three dots next to the filters.
Adding a new tile
To create a new tile in the dashboard, click +Add Tile.
Select whether you wish to add a Visualization or a tile with just Text.
If you select Visualization, you will be able to select an Explore to create a new query in.
If you select Text, enter the title, subtitle, and body of the text you wish to display in the dashboard.
Adding a new dashboard filter
Select Filters to add a new filter or enable or disable cross-filtering.
Select Add Filter to create a new filter or use the toggle to turn cross-filtering on or off. Cross-filtering can be used to filter all dashboard tiles by a single data point from one tile. You can learn more about Looker cross-filtering on dashboards here.
When adding a filter, use the search bar to look for the field you wish to create a filter for. Fields from any Explores used in the dashboard will be available to select.
After selecting the field, use the available options to configure the new filter.
Depending on the type of field selected, the following configuration options will be available:
- Title: enter the title of the filter as you wish to appear in the dashboard.
- Control: select the control type you wish to use for the filter. Controls determine how the filter will appear. The controls available will vary by field type. You can learn more about controls here.
- Display: this option will appear for controls that can be displayed inline or as a popover. If a filter can be displayed only one way, this option will not appear. Learn more about displaying dashboard filters here.
- Values: to set specific values for the filter, choose from the dropdown or enter the value options in this field. For fields with numeric data, this option is replaced by Min and Max fields.
- Configure default value: use this option if you wish to set a default value for the filter.
- Require a filter value: use the checkbox to select whether you wish to require a value for the filter. Learn more about requiring a filter value in Looker here.
- Select filters to update when this filter changes: use the checkbox to choose whether you wish to link other filters to this filter. Linking filters limits the values in the linked filter based on what was selected in the first filter. Learn more about linked filters in Looker here.
Use the Tiles to Update tab to set which tiles the filter should apply to.
When you have finished configuring your filter, click Add.
Configuring refresh and reload settings
To adjust the load and auto-refresh settings for the dashboard, select Settings.
In dashboard settings, you can choose to enable and disable whether you wish the dashboard to run on page load or auto-refresh.
If you disable Run on load, you will need to manually load the dashboard each time you view it.
If you enable Automatically refresh dashboard, you can choose how often you wish the dashboard and the individual tiles to refresh. Keep in mind that enabling auto-refresh for dashboards could have performance impacts.
Note that regardless of what you set in your dashboard settings, the dashboard refresh rate will only be as fast as the refresh rate in the backend (set to every 2 hours or less).
You can also set refresh rates for individual tiles.
When you have finished making changes, click Save.