Exclude Categories that total 0
I am looking to exclude categories on a pie chart when the total for that category=0. I tried creating a couple different beast modes using sum(`revenue`) over (partition by `department`) but they either do not work as a filter or break the card. I would like this value calculated on the fly because the date grain can be changed by the user and and the ins and outs of revenue may happen on different days.
Screenshot of what I would like to exclude from the chart.