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

lee0789
lee0789 Member
in Cards, Dashboards, Stories

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.

Tagged:

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

    A little clunkier than multi-select on a filter, but you could achieve this with multiple variable controls.

    Let's say you want them to be able to select up to 3 Job types, you'd create 3 variables:

    • selection_1
    • selection_2
    • selection_3

    Then create a BeastMode that references the variables and use that BeastMode as your card filter, filtering for "Include". Add your 3 variables as controls. Below's a potential BeastMode, though you may want to add in conditions for default text on your variable controls:

    CASE

    WHEN

    (selection_1 is null) OR (Job_Type like concat('%', selection_1, '%') )

    AND

    (selection_2 is null) OR (Job_Type like concat('%', selection_2, '%') )

    AND

    (selection_3 is null) OR (Job_Type like concat('%', selection_3, '%') )

    THEN 'Include'

    ELSE 'Exclude'

    END

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories