Filtering Multiple Values in One Column with Match Values
Best Answer
-
You can make this work by creating a beast mode that would have the values you are interested in and create a case statement that tags them as a 1 or 'Y' and then everything else gets tagged as a 0 or 'N'. It would look something like this:
(CASE when TRIM(`City`) = 'Abbeville' then 1
when TRIM(`City`) = 'Phoenix' then 1
when TRIM(`City`) ='Albany' then 1
else 0
end)You would then drag your new beast mode field into the filters and select the 1 or Y or whatever you decided on to only show those values. This keeps it from being tied to matching existing values in your dataset.
**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.1
Answers
-
You can make this work by creating a beast mode that would have the values you are interested in and create a case statement that tags them as a 1 or 'Y' and then everything else gets tagged as a 0 or 'N'. It would look something like this:
(CASE when TRIM(`City`) = 'Abbeville' then 1
when TRIM(`City`) = 'Phoenix' then 1
when TRIM(`City`) ='Albany' then 1
else 0
end)You would then drag your new beast mode field into the filters and select the 1 or Y or whatever you decided on to only show those values. This keeps it from being tied to matching existing values in your dataset.
**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.1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 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
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive