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
Adding and Editing Dashboard (Beta) Filters

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.

Understanding Dashboard Filters

Dashboard filters allow a viewer to narrow a dashboard’s results to only the data the viewer is interested in. Dashboard filters can apply to all tiles on a dashboard, one dashboard tile, or no tiles at all (in which case, the filter has no effect on the dashboard).

When viewing a dashboard, a user can temporarily update dashboard filter values, which doesn’t affect any other users. This differs from filters that are part of a query that underlies a dashboard tile, which viewers can’t change unless they can edit the tile or Explore from Here.

To make permanent changes to filters that all users will see, or to add or delete filters, you must have the Manage Access, Edit access level for the dashboard and be in edit mode.

Adding Dashboard (Beta) Filters

Adding a dashboard filter consists of these major steps:

  1. Create the filter itself, which is what users will interact with.
  2. Decide which dashboard tiles should “listen” to that filter. If you don’t do this, Looker applies the filter to any tiles created from the same Explore that the filter is created from.

To get started, make sure the dashboard is in edit mode and that you have at least one query tile or Look-linked tile. Click Filters in the top toolbar. An Add Filter window appears pre-populated with fields from any Explores used in the dashboard. You can use the search bar to find the field you want to filter by, or you can select it from the drop-down menu:

After you select the field you want to filter by, a filter configuration window appears that allows you to customize your filter settings:

  1. Title: Enter the title of the filter as you want it to appear on the dashboard. The title option pre-populates with the name of the filter-by field.
  2. Control: Select from a list of control types, which vary depending on the type of data you are filtering. See the Dashboard (Beta) Filter Controls section to learn more about the different types of controls.
  3. Location: Select the position of the filter. See the Positioning Dashboard (Beta) Filters section to learn more about the different ways to position filters.
  4. Values: To set specific value options for the filter, choose from the drop-down or enter the value options in this field. To allow all value options from the database to be surfaced, leave blank.
  5. Configure Default Value: Optionally, set the default value for the filter.
  6. Add and Cancel: Click one of these buttons to save or cancel the new filter.

The Tiles to Update tab allows you to determine which tiles listen to the filter. Looker begins by automatically applying the filter to any tiles created from the same Explore as the filter and sets the Field to Filter to the same field as the field chosen for the filter:

  1. Select All or None to turn the filter on or off for all tiles.
  2. In the Field to Filter section, choose which field for each tile is affected by the filter, or choose not to apply the filter to that individual tile.
  3. Select Add or Cancel to save or cancel the new filter.

Dashboard (Beta) Filter Controls

Dashboard (beta) filter controls allow you to customize the appearance of filters for dashboard viewers. The filter control types available in the Control drop-down as you create a dashboard (beta) filter depend on the LookML data type assigned to the field you’re filtering on.

To see the data type for a field you are filtering on, you must have the see_lookml permission. You can see the field’s LookML by selecting Go to LookML from the gear menu to the right of the field in the field picker.

s = Works with the string data type
n = Works with the number data type and numeric measures
t = Works with the tier data type
zc = Works with the zipcode data type
yn = Works with the yesno data type

di = Works with the distance data type
du = Works with the duration data type
dt = Works with most date and time data types*
l = Works with the location data type
p = Works with the parameter parameter

ControlDescriptionAppearanceData Types
Multiple Selection
Button Group This type of filter is useful for giving viewers a curated set of limited options. Up to 30 options can be curated in the Values setting. If no values are selected, the first 30 values from the database are shown.

A button is colored once selected.
s n t zc yn di du
Checkboxes Like a button group but with a slightly different design, this type of filter is useful for giving viewers a curated set of limited options. Up to 50 options can be curated in the Values setting. If no values are selected, the first 50 values from the database are shown. s n t zc yn di du
Tag ListA combination of drop-down and checkbox filters. The drop-down options can be curated in the Values setting or all options can be surfaced from the database.

Viewers can expand the drop-down by clicking on the chevron.
s n t zc di du
Range SliderSlider range min and max can be set in the Settings tab of the filter configuration window.

Viewers can set the filter value range by adjusting both ends of the slider.
n di du
Single Selection
Button TogglesThis type of filter is useful for giving viewers a curated set of limited options. Up to 30 options can be curated in the Values setting. If no values are selected, the first 30 values from the database are shown.

A button is colored once selected.
s n t zc yn di du p
Radio ButtonsLike a button toggle but with a slightly different design, this type of filter is useful for giving viewers a curated set of limited options. Up to 50 options can be curated in the Values setting. If no values are selected, the first 50 values from the database are shown. s n t zc yn di du p
Drop-down MenuThe drop-down options can be curated in the Values setting or all options can be surfaced from the database.

Viewers can expand the drop-down by clicking on the chevron and then either selecting an option from the drop-down or typing in the box to narrow the drop-down options. Viewers can also select Any value.
s n t zc yn di du p
SliderSlider min and max can be set in the Settings tab of the filter configuration window.

Viewers can set the filter value by adjusting the right end of the slider.
n di du
Dates and Times
Single Day Viewers can expand to see the calendar by clicking on the date, and select a new day. dt*
The single day control can be
used with most timeframes
and time-based types,
but viewers can only select
single dates with this type
of control.
Date RangeViewers can expand to see the calendar by clicking on the date range, and select a new date range. dt*
The date range control can be
used with most timeframes
and time-based types,
but viewers can only select
date ranges with this type
of control.
TimeframesViewers can select from a set of timeframes built into Looker or create their own custom timeframes by clicking the Custom tab. See the Viewing Dashboards (Beta) documentation page to see the full range of timeframe options for a Timeframes filter.

Timeframes options such as Last 7 Days include the current day. For a timeframe that excludes the current day, select Advanced from the control drop-down and configure the value using complete days.

Viewers can expand to see the timeframe options by clicking on the timeframe.
dt*
The timeframe control can be
used with most timeframes
and time-based types,
but viewers cannot select
time options with this type
of control.
Other
AdvancedSee the Using Advanced Filters section to learn more about advanced filters. s n t zc yn dt di du l p
*Note about Date and Time Data:
Some timeframes and time-based types are interpreted as different data types when Looker is selecting control options for them. Two examples are the yesno timeframe, which is interpreted as a yesno data type, and therefore has the control options available to the yesno type; and the hour_of_day timeframe, which is interpreted as a number data type, and therefore has the control options available to the number type.

Using Advanced Filters

An advanced filter can be applied to all types of data and provides some additional flexibility in the filter conditions you can set up. To create an advanced filter, make sure you have selected Advanced in the Control field of the filter configuration window.

The Configure Default Value field populates with appropriate filter condition options for the type of data you’re filtering. For example, the filter below is filtering on distribution center name, which is a string data type, so the filter condition options include is, contains, starts with, and so on.

Filters on other types of data, such as number or date types, will display different condition options.

Once you’ve selected your filter condition option, you can select a value from the drop-down to the right, which is populated with values from your database. Or, you can type a value to receive a suggestion.

You can also enter a value yourself and click Create “value” to create a value.

You can click the + next to your filter to add new conditions to the filter, which will be added as either OR conditions or AND conditions, depending on the types of conditions and values. To remove a condition, click the X next to that condition.

Advanced Filters, Dates, and Times

While there are several filter controls that allow filtering on dates, you can also use advanced filters with dates. Among other things, using advanced filters allows users to select “complete” ranges that do not include the current time period, by selecting complete days, complete weeks, and so on, in the condition options. This is unlike the timeframe filter control, which includes the current time period.

Advanced filters also allow users to select time values, such as hours, minutes, seconds, and so on.

Matches a User Attribute

Advanced filters also give you the option to select matches a user attribute. This allows you to set filters that change dynamically based on dashboard viewers’ user attributes. See the Filtering and Limiting Data documentation page for more information.

Matches Advanced

The final option in the Configure Default Value option drop-down is matches advanced. With this option selected, you can enter a Looker filter expression to customize a filter beyond the options provided in the options drop-down.

User attributes can also be referenced in matches advanced filters, using the syntax
{{ _user_attributes['name_of_your_attribute'] }}.

Positioning Dashboard (Beta) Filters

To set the position of a filter, make sure your dashboard is in edit mode and select the position in the Location field of the filter configuration window. Dashboard (beta) filters can be positioned in the following ways:

If all filters are placed in the overflow position, the More button will instead read Filters:

Generally, it’s a good idea to place important or frequently used filters in inline or popover positions and less frequently used filters in overflow positions.

Editing Dashboard (Beta) Filters

In edit mode, a pencil icon appears next to every filter.

To edit a filter, click the pencil icon. That opens a filter configuration window, similar to the one used to add a filter, populated with the existing configuration for the filter. From there, you can update the filter-by field, the filter’s settings, or the tiles to update. Select Update or Cancel to save or cancel your changes.

After editing filters, click the dashboard’s reload data icon to apply the new filter settings to the tiles.

Deleting Dashboard (Beta) Filters

In edit mode, a pencil icon appears next to every filter.

To delete a filter, click the pencil icon. That opens the filter configuration window. Click the Delete button to delete your filter entirely. Deleting a filter cannot be undone.

After deleting filters, click the dashboard’s reload data icon to apply the new filter settings to the tiles.

Top