Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- grafana [2021/12/06 08:41] – Fabian Horst
+++ grafana [2021/12/22 10:58] – Fabian Horst
@@ Zeile 1: / Zeile 1: @@
 ====== Grafana Configs ======
+===== Docker Config =====
+<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 =====
@@ Zeile 15: / Zeile 30: @@
 </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>