Metric Filter - Variable

Variable Filter in Metric Filter: Quick Instruction Manual

Using Variable Filter in Metric Filter with Custom SQL

Creating a Metric Filter with Variable Filter:

1. Create Metric Filter

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

3. Assign Variable Name:

   • Assign a variable name, for example, {{value}}.

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