When using a multi-select filter, can this be used as "AND" logic instead of "OR" logic?

I am using a dropdown selector filter in Domo that I have set to allow multiple selections. My goal is to set it so that when 2+ values are selected, the card below it on my dashboard will only bring back rows that meet ALL of the selected values.
For example, if I select "1 Normal Remodel" and "3 Kitchen", the only jobs that I want to display would be the 3 that are highlighted below, as those are the only 3 that meet both criteria in the filter.
Any guidance on this? I'm hoping to avoid a CASE statement that would need to account for any possible combination of selections. I'd be open to exploring an app or custom card type if that's even an option.
Best Answer
-
Currently this isn't possible with a single select however you could have multiple single select filters to get the AND functionality. I'd recommend logging an idea in the idea exchange to add this functionality
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Currently this isn't possible with a single select however you could have multiple single select filters to get the AND functionality. I'd recommend logging an idea in the idea exchange to add this functionality
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive