Create/Modify Dashboard Filter

Click on the "+" icon to add a dashboard filter.

A list of drop-down options are displayed:

• Select: This filter will appear at the top of your dashboard.

• Switch Select: This filter will show up next to the Select filters in the "Filters" section.

• Other: Click the "+" icon in the "Filters" section to view the "Other" filters.

Choose the desired type and variant of the filter from the "Option Type" and "Filter Variant" sections.

Choose the column for which you want to apply the filter.

Toggle over the "Advanced Options" to make it interactable.

Click on "Next" once done.

Apply on:

• Choose the dataset and column for which the filter should be applied.

• In the "Restrict Metrics" drop-down, you can select the columns for which the filter will be restricted.

Variable Filter:

• Use the variable filter to convert data into lowercase and assign a variable name, e.g. {{global_Device Type}}, for future reference in SQL queries.

• Copy the assigned variable {{global_Device Type}} to use in your custom SQL query.

• Refer to the link below for a detailed guide on using the variable filter.

Finally, click on "Save" to create the filter.

To modify the configurations of any dashboard filter, click on the "Edit" button.

To remove a filter, select "Delete" filter.