Is it possible to tie a dashboard filter to multiple fields in the same look? I have two sets of similar data in the same look and would like to be able to filter both sets with one filter.
Solved! Go to Solution.
You could make a filter that filters both conditions. Filters with sql clauses get put in the WHERE clause of the main query. You would then have a single filter you could bind the dashboard to.
Does this help?
filter: employee_and_customer_location {
sql:
{% condition employee.location %} ${employee.location} {% endcondition %}
AND
{% condition employee.location %} ${customer.location} {% endcondition %}
;;