Filters not functioning in Charts Plugin

[bartek.dev]

I am not sure you can do it the way you want. You probably need to use “Group by” and create new expressions to use in value and label.

check this topic:

[New Feature] Grouping and Aggregating Data

Hi all, We’ve heard from many of you that you’d like an efficient way of displaying your app’s data in a chart or table. For instance, maybe you’d like to be able to show a graph of new user signups by month, or show a table of total sales by region and account. We now have a tool for supporting this kind of operation. It’s called “:group by”, and you apply it on top of a search or other list of data items in order to group and summarize the list. [group%20by%20screenshot] The basic conce…