Solved: Date filters in the dashboard with "OR" condition - Page 2

ivancans · 07-30-2024 03:34 AM

It it possible to make 2 or more date filters in the dashboard act based on "OR" and not "AND" condition? This is doable in explore with filter group but as far as I can tell, not possible as a dashboard filter.

This (from dashboard):

would produce this if explored

What I want is the capability in dashboards filter settings to set them up with "OR" condition.

sam8

filter: stripe_refund {
type: date
}

filter: credit_refund {
type: date
}

filter: stripe_or_credit_refund {
type: yesno
sql: {% condition stripe_refund %} ${stripe_refund_date} {% endcondition %} OR {% condition credit_refund %} ${credit_refund_date} {% endcondition %} ;;
}

Something like this should do it! Make filter fields for both of the dates. They don't do anything by themselves. Then, create a yesno field which connects the filter fields to the actual date dimensions.

You'll need to make sure users filter on "yes" for the yesno field, or use like a sql_always_where to make it always enabled on the explore.

View solution in original post