Quelltext der Seite Grafana: Pie Chart

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


== One Query -> multiple Pie slices (recommended) ==
[[Datei:01-grafana pie-chart.png|right]]
'''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".''

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

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
</pre>



== Multiple Queries -> multiple Pie slices ==
[[Datei:02-grafana pie-chart.png|right]]
'''This works also before Grafana 8.x. Add multiple Queries in the Grafana panel.'''

=== InfluxDB Flux Query 1 (for Category-1) ===
<pre>
//define variables
bucket = "<YOUR_BUCKET>"
measurement = "<YOUR_MEASUREMENT>"
field = "<YOUR_FIELD>"

from(bucket: bucket)
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => 
    r._measurement == measurement and
    r._field == field
  )
  |> last()
  |> group()
  |> keep(columns: ["host"])
  |> distinct(column: "host")
  |> count()
  |> rename(columns: {_value: "Category-1"})
</pre>

=== InfluxDB Flux Query 2 (for Category-2) ===
<pre>
//define variables
bucket = "<YOUR_BUCKET>"
measurement = "<YOUR_MEASUREMENT>"
field = "<YOUR_FIELD>"

from(bucket: bucket)
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => 
    r._measurement == measurement and
    r._field == field
  )
  |> last()
  |> group()
  |> keep(columns: ["host"])
  |> distinct(column: "host")
  |> count()
  |> rename(columns: {_value: "Category-2"})
</pre>








[[Kategorie:TIG-Stack]]