I have a super set and I need to use two filters but as an Or clause.

user02990

 

I have a super set and I need to use two filters but as an Or clause. Example Count Jobs where Region is this OR Child Region is this

dthierjung

This is where a "case statement" within a beast mode will solve your problem. For example, create a new beast mode calculation, and you would do something like the following:

 

CASE
WHEN `region` = 'some value' OR `child region` = 'other value'

THEN 1

ELSE 0

END

 

Then you can add this beast mode as a filter, and filter it for when it equals 1. Or you can add a COUNT() function around the entire case statement, but that should be enough to get your started.

 

Let me know if you need further help on that.

user02990

Thank you I will try that and see if that works.