Variable Apply On
In this page you can see the functioning of variable apply on method available in Metric/Dashboard Filters.
Last updated
In this page you can see the functioning of variable apply on method available in Metric/Dashboard Filters.
Last updated
Creating a Metric Filter with Variable Filter:
Create Metric/Dashboard Filter
In the “Apply On” section, choose "Variable Filter".
Assign Variable Name:
Assign a variable name, for example, {{value}}
for Metric Filter, {{global_value}}
for Dashboard Filter.
Copy the variable {{value}}
for use in your custom SQL query.
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: