Case Statement Question - multiple results
I'm trying to use a quick filter to select sales people associated with specific branches. There is some overlap in assignment, in other words two branches are assigned to two different people. Here is my current case statement:
when `Customer Home Branch` IN ('207500','208500') then 'Brad'
when `Customer Home Branch` IN ('203500','207500','208500') then 'Scott'
Here is a video overview of the question I am asking.
Thanks in advance!
- 10.7K All Categories
- 13 Getting Started in the Community
- 38 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
- 501 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board