AND filters in dashbaords

Options
Viswaja
Viswaja Member
in Cards, Dashboards, Stories

When we use a filter to select multiple values in a dashboard it uses an OR statement.
For example : If I want to see all orders containing SKU A and SKU B, how can I achieve that with a filter on a Domo dashboard?

Typically, it only provides orders containing SKU A or SKU B. Hence, I'm curious if there's any method to accomplish this.

Tagged:

Best Answers

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    There are more than one way. The one that comes to mind is to use a dropdown that is to use multiple filter cards, each filtering for a different SKU. For example, you can add two separate filter cards to your dashboard, one for SKU A and one for SKU B. By selecting both SKU A and SKU B in their respective filter cards, you effectively create an AND operation between them.

    You can use slicers (see filter chart types). Use a calculated field where you check for the existence of the SKUs within the column. Dropdown filters with multiselect.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • marcel_luthi
    marcel_luthi Coach
    Answer ✓
    Options

    There are limitations on what Dashboard filters can do for you. Each dimension you add to the filters will be an ADD condition (so criteria for ColumnA and ColumnB both need to evaluate to TRUE), but any additional options you add inside of each of these are used with an OR logic as you've described.

    There could be alternatives, like creating flags for each SKU (not really scalable IMHO), that would allow you to say Contains SKU A needs to be TRUE and Contains SKU B needs to be TRUE. There might be other options by moving away from the Dashboard Filters and using Variables Instead and Beast Modes to create the filtering condition, but that would require some testing.

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    There are more than one way. The one that comes to mind is to use a dropdown that is to use multiple filter cards, each filtering for a different SKU. For example, you can add two separate filter cards to your dashboard, one for SKU A and one for SKU B. By selecting both SKU A and SKU B in their respective filter cards, you effectively create an AND operation between them.

    You can use slicers (see filter chart types). Use a calculated field where you check for the existence of the SKUs within the column. Dropdown filters with multiselect.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ArborRose
    ArborRose Coach
    Options

    In this example, a calculated filter placed on the FILTERS, where = 1.

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • marcel_luthi
    marcel_luthi Coach
    Answer ✓
    Options

    There are limitations on what Dashboard filters can do for you. Each dimension you add to the filters will be an ADD condition (so criteria for ColumnA and ColumnB both need to evaluate to TRUE), but any additional options you add inside of each of these are used with an OR logic as you've described.

    There could be alternatives, like creating flags for each SKU (not really scalable IMHO), that would allow you to say Contains SKU A needs to be TRUE and Contains SKU B needs to be TRUE. There might be other options by moving away from the Dashboard Filters and using Variables Instead and Beast Modes to create the filtering condition, but that would require some testing.

Categories