Supermetrics Support Forum

How do and's and or's work in filters?

I need to use multiple filters at the same time. What are the priorities of the and's and or's? 


i.e. If I use the following filters:


customer ID = A

or customer ID = B

and campaign ID <> X


does the campaign ID filter act as a subset of the customer ID = B filter or does it apply to both of the previous filters?  


Does it work like:

(customer ID = A) or (customer ID = B and campaign ID <> X)

or like 

(customer ID = A or customer ID = B) and (campaign ID <> X)


Thanks!

  • Hi Mark,

    When I tested it to confirm, it appears that the 3rd case applies to both previous filters. So:

    (customer ID = A or customer ID = B) and (campaign ID <> X)


    -Thank you

    Supermetrics Query

  • OK, thanks. I'll test that out. 


    It sounds like you're saying the ORs attach only to the previous condition.

Login to post a comment