home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Editing User-Defined Dashboards

This page describes new Looker dashboards, which are the default Looker dashboards. For information on viewing legacy dashboards, visit the Editing Legacy Dashboards documentation page.

New Looker dashboards have a fresh, modern look and feel; customizable, user-friendly filters; a new dashboard creation experience and editing flow; and improved performance.

For a complete list of dashboards documentation, see the Dashboards documentation page.

Entering Edit Mode in Dashboards

If you have the Manage Access, Edit access level for a dashboard, you can edit it. To edit an existing dashboard, select Edit dashboard from the dashboard menu:

From there you enter edit mode, where you can add, move, or edit tiles or filters, edit the dashboard title, and — if the Cross-filtering Labs feature is enabled — enable cross-filtering for the dashboard.

You can tell you’re in edit mode in a dashboard by the purple toolbar at the top of the dashboard. You exit edit mode by clicking the Save button in the toolbar.

Rearranging and Resizing Tiles

When in edit mode, you can move and resize tiles on a dashboard by clicking and dragging. Click and drag on the six-dot icon in the upper left of a tile to move it. Click and drag on the bottom right corner of the tile to resize it.

Tile Size and Grid Layout

When you add a visualization using grid layout to a dashboard, the grid arrangement can become responsive to the size of the dashboard tile.

For example, say you have a dashboard tile with a visualization that uses a grid layout of four small charts. If you size the tile to be short and wide, the small charts appear as one row of four. If you size the tile as a square, the small charts are repositioned to two rows of two. Or, if you size the tile to be narrow but tall, the charts are repositioned to four rows of one.

To ensure that the grid arrangement is responsive, do not enter a number into the visualization's Number of Charts per Row setting. If you enter a value into Number of Charts per Row, the dashboard tile will respect that setting regardless of the size or shape of the dashboard tile.

Editing Tiles

When a dashboard is in edit mode, the three-dot menu at the top right of each tile shows edit options. These options differ slightly whether you are viewing a query tile or a Look-linked tile:

Editing a Query Tile Title

Once your dashboard is in edit mode, you can edit a query tile’s title simply by clicking on the tile and making your edits. Click Save at the upper right of the dashboard to save your changes.

You can also edit tile titles for both query tiles and Look-linked tiles when editing a tile’s underlying query or Look.

Editing a Tile’s Query or Look

If you save edits to a Look, it will affect every dashboard (new or legacy) where that Look is used.

When a dashboard is in edit mode, you can edit a tile’s underlying query or Look — including the title of the tile and the visualization — directly in the dashboard. First, click Edit in the tile’s three-dot menu.

Looker then displays an edit window for that query or Look, letting you change and save it:

If you are editing a Look, the edit pane displays the dashboards that contain tiles linked to that Look. Those dashboards will be affected by your changes. If you are editing a query tile, you will not see a list of dashboards affected in the edit pane, because your edits only affect the tile and dashboard you are in.

Hiding or Showing a Tile Title

When a dashboard is in edit mode, you can hide or show the title of a tile. By default, tile titles are shown. You can hide a title by clicking Hide title in the tile’s three-dot menu.

Once the title is hidden, the tile’s three-dot menu displays an option to show the title of the tile.

The hide/show option does not appear in the three-dot menu of text tiles or tiles that use single value visualizations. To hide or show the title of a single value visualization, click Edit in the tile’s three-dot menu, toggle the Show Title switch in the style menu, and save. To hide or show a title of a text tile, click Edit in the tile’s three-dot menu, remove or reinstate the tile title, and save.

Adding a Tile Note

To add a note to a tile, make sure the dashboard is in edit mode and then click the Add note button in the tile’s three-dot menu:

Looker shows the following window, letting you enter the note text and select a couple of display options:

  1. Enter the note text you want to show on the tile.
  2. Select the location of the note. The options are above the visualization, below the visualization, or as hover text that appears when users hover over a circled i icon to the right of the tile title. For tiles containing single value visualizations that are sized to be 150 pixels tall or shorter, title notes render as hover text regardless of the location selected in this field.
  3. Check this box to collapse the note by default. A collapsed note shows only the first line, with an ellipsis at the end of the line. Unchecking this box displays the note’s full text by default. If you select On icon hover under Display Location, you will not see this option.
  4. Add the note to the tile or cancel it.

The note appears on the tile with a collapse/expand arrow to the left of the note. Clicking that arrow or anywhere on the note toggles between collapsed and expanded displays.

Once you add a note to a tile, the tile’s three-dot tile menu changes to display Edit note instead of Add note. Click Edit note to reveal a pop-up window similar to the above that will allow you to edit or delete your note.

Duplicating a Query Tile

When the dashboard is in edit mode, you can duplicate query tiles by clicking Duplicate tile from the tile’s menu:

Looker creates a copy of the tile with the same query and visualization settings and adds the new tile to the bottom of the dashboard. From there, you can move or resize the tile, edit the tile title or edit the new tile to adjust the visualization or the underlying query.

You cannot duplicate a Look-linked tile and will not see Duplicate tile in the three-dot menu of Look-linked tiles.

Deleting a Tile

When a dashboard is in edit mode, you can delete a tile from a dashboard by selecting Delete (for a query tile) or Remove Look (for a Look-linked tile) from the tile’s three-dot menu. This deletion cannot be undone.

Deleting a Look-linked tile from a dashboard does not affect the underlying Look.

Editing Dashboard Settings

To edit the settings for a dashboard, make sure the dashboard is in edit mode and then click Settings in the upper left of the purple toolbar:

Run On Load

If Run on load is enabled, dashboard data automatically loads when the dashboard is first loaded.

If Run on load is disabled, the dashboard does not display any data until the reload data icon is clicked.

Autorefresh

It might make sense to automatically refresh the data on a regular schedule to ensure that it is up-to-date. You can set autorefresh frequencies for an entire dashboard or for individual tiles. Autorefresh never pulls results from the Looker cache; it always pulls the data from the database.

To set autorefresh for a dashboard and all its tiles:

  1. Enable the Automatically refresh dashboard switch.
  2. Select a refresh frequency to automatically update the dashboard and all its tiles.
  3. If you want to adjust the frequency for any individual tiles, you can do so in the Tile section, where each tile in the dashboard is listed. Click the drop-down for that tile in the Refresh frequency column, select Refresh every, and then set your frequency.
  4. Click Save to save your changes.

To set autorefresh for individual tiles but not for the dashboard:

  1. Disable the Automatically refresh dashboard switch (if previously enabled).
  2. In the Refresh frequency column of the Tile section, click the drop-down for a tile you want to autorefresh.
  3. Select Refresh every.
  4. Set your frequency.
  5. For any tiles you do not want to autorefresh, leave the setting as Does not refresh.
  6. Click Save to save your changes.

The frequency settings accept whole numbers.

The autorefresh intervals begin at the time of day that you turn on this feature. For example, if you set a daily refresh at 8:33 a.m., the next refresh will occur the next day at 8:33 a.m.

The dashboard refreshes on the interval you set as long as the dashboard is open in a browser tab and is not in edit mode. If the dashboard is closed or in edit mode during a scheduled refresh time, it won’t refresh. The refresh interval restarts as soon as the dashboard is opened again or leaves edit mode. For example, if you set a daily refresh at 8:33 a.m., enter edit mode at 9:02 a.m., and exit edit mode at 9:45 a.m., the daily refresh will now occur at 9:45 a.m.

The Clear cache and refresh and reload data options are independent of the autorefresh interval, meaning that manually refreshing the dashboard does not restart the autorefresh interval. For example, if a dashboard’s autorefresh interval is 1 hour, you can use the Clear cache and refresh option 40 minutes after an autorefresh and the dashboard will still autorefresh 20 minutes later (1 hour after it was last autorefreshed).

Similarly, autorefresh works regardless of whether Run on load is enabled or disabled. If Run on load is disabled and you open a dashboard with autorefresh settings, the refresh interval begins upon opening regardless of whether you click the reload data icon to load the data initially.

Autorefresh and Performance

Use autorefresh cautiously to avoid performance impacts.

Frequent dashboard updates, especially on large dashboards, can place a significant strain on some database systems. You may want to discuss this consideration with one of your Looker admins. At a minimum, avoid setting a refresh interval that is shorter than your database update interval, as if you did so there would be no new data to refresh and this option would trigger unnecessary queries.

Likewise, when multiple users access a dashboard with autorefresh, it may impede performance. If you want to display your dashboard on a shared screen while multiple users simultaneously access it, you can create two identical dashboards and configure only the dashboard on the shared screen to refresh automatically.

Deleting Dashboards

If you have the Manage Access, Edit access level for a dashboard, you can delete it in one of two ways:

Once you delete a dashboard, only a Looker admin can retrieve it from the trash.

Keyboard Shortcuts When Dashboards Are in Edit Mode

To see the keyboard shortcuts you can use when editing dashboards, visit the Keyboard Shortcuts in Looker documentation page.

Top