Dashboard Filter - Variable Apply On

Using Variable Filter in Dashboard Filter with Custom SQL

Creating a Dashboard Filter with Variable Filter:

1. Create Dashboard Filter

2. In the “Apply On” section, choose "Variable Filter".

3. Assign Variable Name:

   • Assign a variable name, for example, {{global_value}} for Dashboard Filter.

   • Copy the variable {{global_value}} for use in your custom SQL query.

Example Use Case: Dynamic Country Population Analysis

Let's say you're building a dashboard where analysts need to quickly filter population data for different countries without modifying the underlying SQL query each time. Here's how the Dashboard Filter would be valuable:

Purpose:

• Allows users to dynamically select different countries to view their population data

• Eliminates the need to write separate queries for each country

• Provides a user-friendly interface for non-technical users

Example Custom SQL Query with Variable Filter:

• Custom SQL you write:

• Custom SQL added with Variable Filter:

Then the Generated SQL we generate would look like this:

• Resulting SQL:

Working:

• Initial SQL query gets all country population data

• Variable Filter adds a WHERE clause with {{global_value}}

• When users select a country from the filter, it automatically updates the query

• Results are instantly filtered to show only the selected country's data

Dashboard Result After Applying Filter with Variable Value

The metrics are filtered according to the values selected in the dashboard filter