While you can still create the filter, you cannot apply multiple filters that use the same field to the same dashboard tile.
If you want to create a filter on a field from an Explore that is not used in the dashboard, see the Advanced filters section on this page.
If you have already selected a field in the filter by dialog box of the Add Filter window, clicking the Advanced switch results in no changes to the Add Filter window and an advanced filter is not initiated.
Once you've selected the field you want to filter by, click Add.
Adding dashboard filters
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, and then click Add Filter. An Add Filter window appears next.
The Add Filter window appears pre-populated with fields (dimensions or measures) from any Explores that were used in the creation of this dashboard's tiles. For example, the following Add Filter window shows the Explores that are presently used in the dashboard's tiles: the Flights Explore from the E Faa model and the Order Items Explore from the MB ecommerce_demo model
- Clicking the arrow to the left of an Explore expands the Explore to show the Explore's views.
Each view can then be expanded to reveal the view's fields. To filter on a field from one of these Explores, you can use the Filter by dialog box to search for fields or manually enter a field name.
You can also click a field name, such as Order ID, to add it to the Filter by dialog box: If you select a field that is already being used by another filter, you will receive an alert message.
Advanced filters
Advanced filters let you create dashboard filters using fields that are outside of the Explores used to create tiles on the dashboard.
Click the Advanced switch to use advanced filters. This updates the Add Filter window with options to select a model, an Explore, and a field with which to create the filter.
First, select a model name from the drop-down Model menu.
The drop-down menu contains all models that you have access to.
Once a model is selected, the Explore dialog box populates with a drop-down menu of all the Explores that are present in the selected model.
Once the model and the Explore are selected, the fields that are available in that Explore will populate the Add Filter window.
You can use the search bar to find the field that you want to filter by, or you can click a field name to select it. Once you've selected the field you want to filter by, click Add.
Customizing filter configuration
Once you select a filter field and click Add, the Add Filter window shows a variety of customizable settings:
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.
Control: select from a list of control types, which vary depending on the type of data you are filtering. See the Dashboard filter controls section on this page to learn more about the different types of controls.
Display: for controls that can be displayed as either inline or popover, select how the filter will be displayed. See the Displaying dashboard filters section on this page to learn more about the different ways to display filters. If a control can be displayed only in one way, this option will not appear.
Values: to set specific value options for the filter, choose from the drop-down or enter the value options in this field. Leave blank to allow value options from the database to be surfaced, up to the maximum number of values available for that control. For numeric data, this field is replaced by the Min and Max fields.
Configure Default Value: optional, use to set the default value for the filter
Require a filter value: select the checkbox to require a value for the filter. See the Requiring a filter value section on this page to learn more about requiring filter values.
Select filters to update when this filter changes: select the checkbox to link other filters to this filter. See the Setting up linked filters section on this page to learn more about linked filters. If there are no other filters on the dashboard, this option will be disabled.
Add and Cancel: click one of these buttons to save or cancel the new filter
The Tiles To Update tab lets you determine which tiles listen to the filter. Advanced Reporting begins by automatically applying the filter to any tiles that were created from the same Explore as the filter and sets the value of Field to Filter to the same field as the field chosen for the filter:
Select All or None to turn the filter on or off for all tiles.
In the Field to Filter section, for each tile, choose which field will be affected by the filter, or choose not to apply the filter to an individual tile.
If you select a field that is already used in an existing filter, any tiles filtered by the existing filter are unavailable to the new filter.
Select Add or Cancel to save or cancel the new filter.
If any new tiles are added to the dashboard after the filter is created, if they were created from the same Explore as the filter, the dashboard filter is automatically applied to that tile.
For further information see the Looker documentation for: Dashboard filter controls.
Displaying Dashboard filters
You have several options for altering the way dashboard filters are displayed. You can adjust the appearance of individual filter controls or of the entire filter bar.
Appearance of individual filters
To set the way a filter appears, first make sure your dashboard is in edit mode and then select the style of display in the Display field of the filter configuration window that appears when you select Edit from the filter menu. Most dashboard filters can be displayed in the following ways:
Inline: The filter is displayed directly in the top bar of the dashboard.
Popover: A summary value appears in the top bar of the dashboard; click the value to see the full filter.
Filters can also be placed behind a More button: A More button will appear in the filter bar with an indicator that shows the number of filters the bar contains; viewers can click the button to see the filters and their values.
Some filter controls can be displayed only in inline orientation; when you edit a dashboard with these filter controls, you won't see a Display field in the filter configuration window. These filter controls can be displayed only in inline orientation:
Drop-down Menu
Single Day
Timeframes
Date Range
Additionally, some filter controls can be displayed only in popover orientation; when you edit a dashboard with these filter controls, you won't see a Display field in the filter configuration window. These filter controls can be displayed only in popover orientation:
Tag List
Advanced
Generally, we recommend that important or frequently used filters be displayed as inline or popover, and less frequently used filters be displayed as overflow.
Appearance of the filter bar
To set the way a filter bar appears, follow these steps:
Make sure your dashboard is in edit mode.
Open the dashboard's Settings window.
Click the Filters tab of the Settings window.
You can set the Default filters view option to Expanded or Collapsed. (The default is Expanded.)
The Filters location option allows you to place the filter bar at the top or the right of the dashboard. (The default is at the top.)
Editing dashboard filters
In edit mode, a three-dot Filter Menu icon appears next to every filter.
To edit a filter:
Click the icon. This opens the filter menu, which displays options to edit or delete a filter.
Select the Edit menu option to open 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 in the filter configuration window to save or cancel your changes.
Once you've edited filters, click the dashboard's Update button to apply the new filter settings to the tiles.
Click Save to save your changes and exit edit mode.
Deleting dashboard filters
In edit mode, three-dot Filter Menu icon appears next to every filter.
To delete a filter:
Click the three-dot Filter Menu icon. \ This menu displays options to edit or delete a filter.
Select the Delete menu option to delete the filter.
Click Save to save your changes and exit edit mode.
Once you've deleted the filters, click the dashboard's Update button to apply the new filter settings to the tiles.
Alternatively, you can select the Edit menu option, which opens the filter configuration window. Click the Delete button within the filter configuration window to delete your filter.