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
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 465 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive