Before you begin
Plans: Professional and Enterprise
Audience: Creators
To add a filter to a look:
-
Open the look in edit mode. To learn how, see Edit a look.
-
In the field list next to the field you want to add a filter for, click the filter icon:
-
In the Filters section, select the operator (is equal to, contains, etc.) you want to use from the drop-down list:
-
In the field provided, enter the criteria you want to filter for:
-
(Optional) To add another statement to your filter:
-
Click the + button:
For example, you could add another statement to filter for work orders that are low priority or don't have a priority assigned.
Note: The application automatically selects whether the statement uses AND or OR depending on the operators you select.
-
Repeat steps 3 and 4 to configure the statement.
-
-
Click Save.
Tips
- If you want to filter on multiple dates, add the Filter all dates field and select the time period you want to include. The filter will include a work order if any of its dates (suggested completion date, completed date, or created date) fall within the specified time period.
- Want to create your own custom filter? Select the Custom Filter checkbox in the Filter section header. The application displays a Custom Filter field where you can define your filter using LookML. To learn more about LookML, see Looker functions and operations in the Looker documentation.