Solved: Dashboard filters tied to multiple fields in same ... - Page 2

Brian_Winkle · 07-27-2016 01:01 PM

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.

lloydtabb

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 %}
  ;;

View solution in original post

Dashboard filters tied to multiple fields in same look