Need help creating an AND OR filter using Beast Mode

I need my data to filter based upon a couple of criteria.

If the database column titled source_name equals 'shopify_draft_order', I need the data to show.

Also, if the database column titled referring_site is blank and another column titled landing_site contains the word 'invoice', I need that data to show as well.

Not sure if I am close or not, but here's what I've come up with so far and assuming I would need to do this in Beast Mode:

CASE WHEN `source_name` IS 'shopify_draft_order' OR WHEN `referring_site` IS NULL AND `landing_site` CONTAINS 'invoice' THEN...

Any advice would be greatly appreciated.

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Try something like this:

    CASE WHEN `source_name` = 'shopify_draft_order' OR (`referring_site` IS NULL AND `landing_site` LIKE '%invoice%') THEN
      [DO STUFF HERE WHEN IT MATCHES YOUR CRITERIA]
    END
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Try something like this:

    CASE WHEN `source_name` = 'shopify_draft_order' OR (`referring_site` IS NULL AND `landing_site` LIKE '%invoice%') THEN
      [DO STUFF HERE WHEN IT MATCHES YOUR CRITERIA]
    END
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • malmy
    malmy Member

    Thank you! Super helpful.