grafana

Dies ist eine alte Version des Dokuments!


Grafana Configs

from(bucket: "iotkiel")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "http_listener_v2")
  |> filter(fn: (r) => r["_field"] == "uplink_message_decoded_payload_payloads_1_registers_0_values_0")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> map(fn: (r) => ({ r with _value: r._value / 1000.0 }))
  |> toFloat()
  |> yield(name: "mean")

Watt

from(bucket: "iotkiel")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "http_listener_v2")
  |> filter(fn: (r) => r["_field"] == "uplink_message_decoded_payload_Watt")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> toFloat()
  |> yield(name: "mean")

Ampere

from(bucket: "iotkiel")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "http_listener_v2")
  |> filter(fn: (r) => r["_field"] == "uplink_message_decoded_payload_Ampere")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> toFloat()
  |> yield(name: "mean")

Volt

from(bucket: "iotkiel")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "http_listener_v2")
  |> filter(fn: (r) => r["_field"] == "uplink_message_decoded_payload_Volt")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> toFloat()
  |> yield(name: "mean")
  • grafana.1638780385.txt.gz
  • Zuletzt geändert: 2021/12/06 09:46
  • von Fabian Horst