Charts: Set Individual Filters for each Chart

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.

4 Likes

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

2 Likes

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

1 Like

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 |
±------------±-------------+