Nested Filters

Reply
Highlighted
Orange Belt

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 🙂

 

Thanks!

Nested Filter.png


Accepted Solutions
Highlighted
Black Belt

@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.

 

Capture.PNG


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post


All Replies
Highlighted
Black Belt

@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.

 

Capture.PNG


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post

Highlighted
Orange Belt

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!

Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.