Create/Modify Dashboard Filter

Dashboard filters allow for more precise data viewing and analysis within your dashboard.

1. Add Dashboard Filters:

• 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.

2. Configuring a Filter:

• 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.

3. Apply on and Variable Filter:

• 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.

Metric Filter - Variable

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

4. Modify Dashboard Filter:

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

• To remove a filter, select "Delete" filter.