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 toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 807 Beast Mode
- 80 App Studio
- 44 Variables
- 761 Automate
- 189 Apps
- 480 APIs & Domo Developer
- 75 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive