Skip to Main Content
Preset Feature Feedback
Status Needs review
Categories New feature
Created by Guest
Created on Jun 7, 2023

Allow QUALIFY filters on charts

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.