At the minute we can use a HAVING statement in the chart filters to remove rows that have below a certain count from a chart. However there might be times we want to filter based on counts in the parent category. For example in a stacked bar chart showing % positive, negative and neutral reviews per film, I might want to filter out any films with fewer than 100 ratings. With HAVING this isn't possible.
See attached images - I'd like to filter out Jaws 2 but not Jaws 1 since the total number of reviews is greater than 100. When I use HAVING I lose the negative reviews for Jaws 1 which means it appears as having 100% positive rating.
Allowing a QUALIFY statement in the chart filter would enable filtering out based on counts per film.
Some relevant links:
https://apache-superset.slack.com/archives/C016B3LG5B4/p1657642055205299
https://github.com/apache/superset/discussions/20686