Filtering Multiple Values in One Column with Match Values
When filtering with Match Values as in the screenshot below, does Domo intuitively understand that these are all individual things to filter out? I cannot use a selection filter in my case because the values are not currently in the data but may be included in the future.
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
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 818 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 191 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 408 Distribute
- 116 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive