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