Grafana: Pie Chart

Following are two examples to make great Pie Chart with Grafana and InfluxDB Flux.

One Query -> multiple Pie slices (recommended)

This works only with Grafana 8.x or higher!

InfluxDB Flux Query

Create a Grafana Pie chart panel that shows the count of unique hosts per SLA. We named the SLA's (in Influx tag "sla") as precious metals for example "Gold".

//define variables
bucket = "<YOUR_BUCKET>"
measurement = "<YOUR_MEASUREMENT>"
field = "<YOUR_FIELD>"
group = "<YOUR_GROUP/YOUR_SLICES>" //in this examples the 

from(bucket: bucket)
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => 
    r._measurement == measurement and
    r._field == field
  )
  |> last()
  |> group()
  |> unique(column: "host")
  |> group(columns: ["sla"])
  |> count()
  |> rename(columns: {_value: ""}) //remove _value from Pie slice naming