Bar chart - Group categories together

  • What Grafana version and what operating system are you using?

9.4.3 - Ubuntu

  • What are you trying to achieve?

I have an Elasticsearch datasource with task data, like id, name, priority and status.

I need to show two bars. The first should count all tasks (including all statuses). The second one should show only tasks that are done. Like the image below:

The graph above was made using the old Graph panel. It was made using two queries:

Query A: documentType:"task" AND priorityName:"High"
Query B: documentType:"task" AND priorityName:"High" AND statusName:"Done"

  • How are you trying to achieve it?

I’m trying to migrate the panel above to the new Bar Chart panel. But the above solution doesn’t work.

  • What happened?

If I use the same two queries, it shows the error Bar charts requires a string or time field.

If I keep only one query, it kinda works, but it shows every status as a separate bar, like below:

Could you guys point me in the right direction?

Solved by using Bar Gauge instead of Bar Chart. Using the same queries as above and setting the reducer function of the “Calculation” field as “Total”.