AND filters in dashbaords
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.
Best Answers
-
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! **0 -
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.
0
Answers
-
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! **0 -
In this example, a calculated filter placed on the FILTERS, where = 1.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
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.
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 280 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 562 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 586 Beast Mode
- 13 App Studio
- 28 Variables
- 585 Automate
- 142 Apps
- 415 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Release Questions
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive