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

user02990
user02990
in Archive

 

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

Comments

  • dthierjung
    dthierjung Contributor

    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
    user02990

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

Categories