====== Grafana Configs ======

===== Docker Config =====
von: https://grafana.com/docs/grafana/latest/installation/docker/
<code>
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:
</code>

===== Klax Sensor =====
{{:2021-12-06-zaehlerstandgrafana.png?200|}}
<code>
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")
</code>

===== RZ Sensor =====

Watt
{{:2021-12-06-zaehlerstandwatt.png?200|}}
<code>
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")
</code>  

Ampere
{{:2021-12-06-zaehlerstandampere.png?200|}}
<code>
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")
</code>

Volt
{{:2021-12-06-zaehlerstandvolt.png?200|}}
<code>
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")
</code>