How can I have an 'OR' condition on Quick Filters?


I have a two quick filters on two separate fields. I would like to be able to select the filters with the option of OR ing the two rather than AND ing. Currently I have set up a calculated field concatenating both fields and then provide the quick filter on the calc field with the contains option. Would love to have the end user the option.
Best Answers
-
This is currently not an option in Domo. I would suggest submitting this idea to the
If it were me I would do what you've mentioned and create custom "OR" conditions in a beastmode and present those options as a quick filter.
If I solved your problem, please select "yes" above
0 -
@dmurgit1 Depending on your use case, you may be able to use two variable controls and a beast mode filter to accomplish this. You would have to set the values of each variable for all possible values of the corresponding field, so this would only be feasible if your fields have a fairly small and static list of values. This is what the beast mode filter would look like in this scenario:
case when `Field1` = `Var1` then 'Include' when `Field2` = `Var2` then 'Include' else 'Exclude' end
0
Answers
-
This is currently not an option in Domo. I would suggest submitting this idea to the
If it were me I would do what you've mentioned and create custom "OR" conditions in a beastmode and present those options as a quick filter.
If I solved your problem, please select "yes" above
0 -
@dmurgit1 Depending on your use case, you may be able to use two variable controls and a beast mode filter to accomplish this. You would have to set the values of each variable for all possible values of the corresponding field, so this would only be feasible if your fields have a fairly small and static list of values. This is what the beast mode filter would look like in this scenario:
case when `Field1` = `Var1` then 'Include' when `Field2` = `Var2` then 'Include' else 'Exclude' end
0 -
Thank you. Our use case is a dynamic list of values. Too big to put in a use case.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 742 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive