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.

2025-05-23_11h23_15.png

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

  • GrantSmith
    GrantSmith Coach
    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!**

Answers

  • GrantSmith
    GrantSmith Coach
    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!**