Cascading filters in Superset Filter Box

[t0nydean]

When you are filtering by more than one element, the values chosen in previous filters should limit the choices in subsequent drop downs
Consider the Country - State - City example....or any hierarchy of values really.

I would like to have filters applied in sequence, so that if I choose 'USA' from my country filter, I only get options relevant within USA. Then if I choose 'Ohio' from my state drop down, I would only get cities in OH from my 'City' drop down.

We can create multiple filters that apply to each other but the visual is bad...the filters take up way too much room on the screen.

I know this has been proposed before ( 5664 ) but seems like it was shelved dues to some other filtering changes coming, what happened to that?

[issue-label-bot]

Issue-Label Bot is automatically applying the label #enhancement to this issue, with a confidence of 0.67. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[nytai]

@t0nydean This seems like a feature that would be useful. I can't think of any good reasons we wouldn't want filter to cascade, thought it is a change in behavior. This could probably be wrapped in a config flag if there are use cases for maintaining current behavior. Would you be interested in reviving the old PR (#5664) and working on this? I'd be happy to review and help get this in.

[t0nydean]

sorry I am not able to contribute code, the old PR was fully approved if its just a matter of re-requesting it I maybe can do that?

[nytai]

That PR is fairly old so it's unlikely it's just work without needing to resolve some merge conflicts. Maybe someone else in the community can take this effort on as we're quite busy with other efforts at the moment

[junlincc]

🏷 filter

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[junlincc]

#12148
dashboard native filter and cascading filter are available for testing!! thanks in advance for feedback, comments, critics, love and support!!

[marituhone]

@junlincc is the issue get fixed can we cascade filters based on parent filter?

[rusackas]

Yes you can... they're called "dependent filters" in the filter config.