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.
- 10.7K All Categories
- 13 Getting Started in the Community
- 39 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board