Nested Filters
Hi all,
I’ve run into a puzzle on a dashboard and am wondering if you have advice. (See screenshot for dummy data to illustrate the issue).
All charts in the dashboard are filtered by the “State” column.
Initially, we were going to just have the user select their “State” in a filter. The issue is that “State” is kind of a super-category. Multiple “Parks” might be in one state. (Each park corresponds to one and only one state). A user will for sure know which park they are in, but might not know which state that park belongs to.
So the ideal output is to have a filter on the dashboard for “Park.” The user chooses their “Park,” and then all cards on the dashboard are filtered by the corresponding “State.” (We’d also have a card informing the user which state their park pertains to).
Is it possible to filter by a field ("State") that is “looked up” by another filter ("Park")?
@jaeW_at_Onyx you know you want to make a video for this one
Best Answer
-
@rgbuckley no video required! ?
it sounds like you want to apply a filter (Park) that then applies a 'looser' filter' on the data (State). The short answer is ... no the Domo UI can't do that yet. An upcoming feature 'Filter Groups' may help with that.
What you can do if you only have a few parks per state, you could duplicate the entire State data for each park in that State.
So if I had Crystal Lake, and Ainsworth and Angel's Rest in OR, then I would duplicate the data 3x one for each Park. Then you don't have to worry about applying a 'looser' filter.
Then when the Park Group = Group Actual, then I know that's data about THAT park.
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"1
Answers
-
@rgbuckley no video required! ?
it sounds like you want to apply a filter (Park) that then applies a 'looser' filter' on the data (State). The short answer is ... no the Domo UI can't do that yet. An upcoming feature 'Filter Groups' may help with that.
What you can do if you only have a few parks per state, you could duplicate the entire State data for each park in that State.
So if I had Crystal Lake, and Ainsworth and Angel's Rest in OR, then I would duplicate the data 3x one for each Park. Then you don't have to worry about applying a 'looser' filter.
Then when the Park Group = Group Actual, then I know that's data about THAT park.
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"1 -
Thanks Jae!
I ended up taking your advice and cross joined park and state. The filtering then worked! And be concatenating park and state and then using distinct count I was able to mostly preserve accurate aggregations despite the increased row count. Much appreciated!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive