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
@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
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
- 7.6K All Categories
- 913 Connectors
- 241 Workbench
- 470 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 23 Visualize
- 194 Beast Mode
- 2K Charting
- 6 Variables
- 14 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
- 14 Manage
- 35 Governance & Security
- 17 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部