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