Grafana Configs

von: https://grafana.com/docs/grafana/latest/installation/docker/

grafana:
    image: grafana/grafana-oss:main-ubuntu
    container_name: grafana
    restart: unless-stopped
    ports:
      - 3000:3000
    volumes:
      - /docker/grafana:/var/lib/grafana
    user: "1000" # USER ID des Docker Users anpassen

volumes:
  grafana:

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")