How to Display Count of Values in a Pie Chart Grafana, data coming from a single column?

[pranavbilurkar28]

Hi Grafana community,

I’m working on a Grafana dashboard where I have a Column with a single field named Enable_Status. This field contains two possible values: “Enabled” and “Not Enabled”. I would like to visualize the count of each status in a Pie Chart to show the percentage distribution of “Enabled” vs. “Not Enabled”.

The table view of the query shows multiple rows of Enable_Status like this:

Enable_Status
Not Enabled
Not Enabled
Enabled
Not Enabled

Question:

How can I count the occurrences of each distinct value (i.e., “Enabled” and “Not Enabled”) in the Enable_Status field and visualize the percentage distribution in a Pie Chart?

I’ve tried Group By and Reduce transformations, but I’m either missing a step or using the wrong transformations. Any guidance on how to achieve this would be greatly appreciated!

NOTE - Data is coming from Prometheus DB

[sowdenraymond]

use the partition transform:

then a reduce transform:

then join them back together with a concat:

then you get the data with the counts:

then you can make it a pie chart: