Bar chart - Group categories together

Grafana Bar Chart Panel
1
  • 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:

image
image1476×315 7.98 KB

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:

image
image1476×315 13.6 KB

Could you guys point me in the right direction?

2

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”.