Usecase: I want to Display the Number (chart typ Statistic) of Tasks that are: Open, In progress, done.
Problem: I can only set the filter “status=open” for the entire charts item, not for an individual chart.
Suggestion: Add Filters on Charts Level.
Great suggestion @_4N ! Completely agree
For anyone looking for something similar, we do support filtering chart series, in bar, line, area, pie etc, but not in statistics.
Something we hope to support soon
If it’s a blank page, you can always add multiple chart items, and set the filter for the chart item (as you suggested)
But individual filters would be best
Not sure if this helps, but if you can use query’s, a short term fix that I use is the following sample for statistics chart. Then add 3 statistic charts based on that query as source.
SELECT
case_status,
COUNT(*) AS status_count
FROM
cases_table
WHERE
case_status IN (‘Open’, ‘In Progress’, ‘Completed’)
GROUP BY
case_status;
±------------±-------------+
| case_status | status_count |
±------------±-------------+
| Open | 120 |
| In Contact | 45 |
| Completed | 90 |
±------------±-------------+