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
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive