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:
case
when `Customer Home Branch` IN ('207500','208500') then 'Brad'
when `Customer Home Branch` IN ('203500','207500','208500') then 'Scott'
end
Here is a video overview of the question I am asking.
Thanks in advance!
Comments
-
The easiest solution would be to add an additional statement that resulted in "Brad/Scott" like this:
case
when `Customer Home Branch` IN ('207500','208500') then 'Brad/Scott'
when `Customer Home Branch` IN ('203500') then 'Scott'
endHowever, I think you are wanting to be able to have Brad and Scott listed individually. If that is the case you are likely going to need to do a Magic ETL and use the JOIN functionality to join your current dataset with a dataset that has a listing of branches and their managers and branch 207500 and 208500 would have 2 entries in that dataset, one for Brad and one for Scott. It will duplicate the rows for those branches in your main dataset, so you'll need to be careful how you sum, but it would allow you to use the Quick Filter how you would like.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive