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 Dashboards (Beta)

add

New in Looker 7.16, you can enable or disable dashboard- and tile-level autorefresh in dashboards (beta).

Dashboards (beta) are a new version of Looker dashboards that have a fresh, modern look and feel; customizable, user-friendly filters; a new dashboard creation experience and editing flow; and improved performance.

If your admin has enabled the New Dashboard Experience Labs feature, you can use dashboards (beta). You can also switch back and forth between dashboards (beta) and Looker’s original dashboards.

For a complete list of dashboards (beta) documentation, see the Dashboards (Beta) documentation page.

Entering Edit Mode in Dashboards (Beta)

If you have the Manage Access, Edit access level for a dashboard, you can edit it. To edit an existing dashboard (beta), 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 (beta) 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 (beta) 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 (beta), 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 (beta) 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 (beta or original) where that Look is used.

When a dashboard (beta) 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 (beta) 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.
  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 (beta) 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 (Beta) Settings

add

New in Looker 7.16, you can enable or disable dashboard- and tile-level autorefresh in dashboards (beta).

To edit the settings for a dashboard (beta), 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 (beta) data automatically loads when the dashboard is first loaded.

If Run on load is disabled, the dashboard (beta) 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 (Beta)

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

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

Keyboard Shortcuts When Dashboards (Beta) Are in Edit Mode

There are a variety of keyboard shortcuts available for users in Looker. The shortcuts vary by location in the Looker application. To see a list of the available shortcuts, you can choose Keyboard Shortcuts from the Help menu. You can also press the ? key on your keyboard to see the available shortcuts.

Depending on your permissions and the access level you have for a dashboard, these are the shortcuts you can use when dashboards (beta) are in edit mode. They differ slightly from the shortcuts available for original dashboards. Visit the Viewing Dashboards (Beta) documentation page to see the keyboard shortcuts available when viewing dashboards (beta).

Shortcut                                                                                                 MacWindows
Show or hide shortcut menu ??
Reload data Command-ReturnCtrl+Enter
Add text tileOption-Shift-TAlt+Shift+T
Add query tileOption-Shift-VAlt+Shift+V
Save Command-SCtrl+S
Add filterOption-Shift-FAlt+Shift+F

Visit the Keyboard Shortcuts in Looker documentation page to learn more about Looker’s keyboard shortcuts.

Top