Metric Filter - Custom
Create a Custom Dashboard/Metric Filter: Quick Instruction Manual
Create Metric Filter:
Begin by creating a new metric filter within your dashboard.
Write Your Custom SQL Query:
Create a SQL query to retrieve the data you need for options in drop down. For example:
Mention the Alias in the Option:
In your filter options, refer to the alias
countryname
that you used in your SQL query.
Navigate to "Apply On" Section:
Go to the "Apply On" section of the dashboard filter settings.
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
Write Your Custom SQL:
Start by writing a basic SQL query without the filter.
Integrate the Variable Filter:
Modify your SQL to include the variable filter.
Resulting SQL Generated:
The resulting SQL generated by the system will incorporate your variable filter in the final output.
Last updated