Using Separate Filters in a Dashboard as an OR type argument
I have a situation in which I have a High Roll-up of States grouped together and then a separate State level filter and want them to work together. Example is:
And then a State Filter of all 50 states.
I would like to have the have an option to pull in data that can include rows that satisfy either the Geographic OR the State filter. So for example user selects "East" and then can also specifically select "California" in the State Filter. Then the data has all the rows with Region = East and also the rows with State = "California". Is this possible? I'm using the Filter cards and applying it in the DOMO dashboard.
Further note, what is going on is that when I select say "East" under the Region filter, I will then only be offered states to choose from on the East Coast in my State filter. In a way, I don't want the Region filter to then dictates what's availble to select in the State filter.
Unfortunately, the dashboard filters are set to work on an AND condition. Maybe not ideal, but you could could have one card that shows states totals and another card that shows region totals and have them sit next to each other in your dashboard. If you are using the filter cards, you can tell it which cards should be affected when the filter is applied.**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
I've run into this myself in the past. One workaround I have used (though admittedly not the most elegant solution) is simply to CONCAT() the two filter fields together in Beast Mode.
This allows you to at least see the entire list of values when you filter. Super manual, but with a max list size of 50 values, it's not too tedious.
`Region - State` = CONCAT(`Region`, `State`)
Serving up data insights since 2002...0
@MarkSnodgrass and everyone else... stay tuned and check the next set of release notes ... there maaaaaay be a feature in the pipes that can help with your use case.Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
- 7.7K All Categories
- 3 Connect
- 919 Connectors
- 244 Workbench
- 477 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 38 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 19 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 27 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 14 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部