- ioBroker Community Home
- Deutsch
- Skripten / Logik
- Blockly
- Wasserverbrauch tageweise loggen und anzeigen
NEWS
Wasserverbrauch tageweise loggen und anzeigen
-
@coachi sagte: Folgendes Blockly hab ich erstellt:
Ich komme mit den Datenpunktnamen und Variablenbezeichnern nicht zurecht.
Eigentlich müsste es, ausgehend vom Zählerstand, so aussehen:
@paul53 sagte in Wasserverbrauch tageweise loggen und anzeigen:
Ich komme mit den Datenpunktnamen und Variablenbezeichnern nicht zurecht.
ich bin davon ausgegangen dass es irgendwo schon etwas gibt, dass den heutigen Verbrauch kumuliert und in den triggernden DP schreibt
kein Support per PN! - Fragen im Forum stellen - es gibt fast nichts, was nicht auch für andere interessant ist.
Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.
der Installationsfixer: curl -fsL https://iobroker.net/fix.sh | bash -
-
@paul53 sagte in Wasserverbrauch tageweise loggen und anzeigen:
Ich komme mit den Datenpunktnamen und Variablenbezeichnern nicht zurecht.
ich bin davon ausgegangen dass es irgendwo schon etwas gibt, dass den heutigen Verbrauch kumuliert und in den triggernden DP schreibt
@homoran sagte: etwas gibt, dass den heutigen Verbrauch kumuliert und in den triggernden DP schreibt
Dann ist aber in dem Skript "Wasser_Zählerstand_gestern" = "Verbrauch_heute" um 23:59 Uhr. Das passt von den Namen her nicht.
Bitte verzichtet auf Chat-Nachrichten, denn die Handhabung ist grauenhaft !
Produktiv: RPi 2 mit S.USV, HM-MOD-RPI und SLC-USB-Stick mit root fs -
@homoran sagte: etwas gibt, dass den heutigen Verbrauch kumuliert und in den triggernden DP schreibt
Dann ist aber in dem Skript "Wasser_Zählerstand_gestern" = "Verbrauch_heute" um 23:59 Uhr. Das passt von den Namen her nicht.
@paul53 sagte in Wasserverbrauch tageweise loggen und anzeigen:
Das passt von den Namen her nicht.
korrekt! das passt nicht. Ist aber nicht der erste, der heute den "gestrigen" Verbrauch reinschreibt, weil er ihn morgen erst sieht.
Frei nach dem Motto: morgen ist heute gesternkein Support per PN! - Fragen im Forum stellen - es gibt fast nichts, was nicht auch für andere interessant ist.
Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.
der Installationsfixer: curl -fsL https://iobroker.net/fix.sh | bash -
-
Hallo,
ich versuche gerade mit iobroker und Blockly meinen Wasserverbrauch tageweise zu loggen und mit Grafana darzustellen.
Folgendes Blockly hab ich erstellt:

Den aktuellen Verbrauch bekomme ich geliefert, den kann ich auch darstellen. Aber ich würde gerne jeden Tag immer einen Monat lange sehen.

Ist das so wie ich das versuche möglich?
Viele Grüße
@coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:
Den aktuellen Verbrauch bekomme ich geliefert, den kann ich auch darstellen. Aber ich würde gerne jeden Tag immer einen Monat lange sehen
Das kannst du mit Grafana, dazu benötigst du nicht jeden Tag, sondern nur deinen Gesamtzählerstand, den Rest macht Grafana
umgestiegen von Proxmox auf Unraid
-
@coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:
Den aktuellen Verbrauch bekomme ich geliefert, den kann ich auch darstellen. Aber ich würde gerne jeden Tag immer einen Monat lange sehen
Das kannst du mit Grafana, dazu benötigst du nicht jeden Tag, sondern nur deinen Gesamtzählerstand, den Rest macht Grafana
@crunchip Das war mein ursprünglicher Gedanke, aber ich hab das nicht hinbekommen mit Grafana. Ich logge jetzt einfach mal den Gesamtzähler mit. Wie müssen die Einstellungen in Grafana aussehen wenn ich den tageweisen Verbrauch anzeigen will?
@paul53, @Homoran , ich hab viel rum gespielt die letzte Zeit weil ich es nicht hinbekommen hab. Deswegen auch die Frage am Anfang ob man das so macht :-) Aber wenn crunchip sagt das es mit Grafana auch geht, wär mir das lieber ;-)
Mal sehen was er antwortet, wenn es nicht klappt dann versuche ich die andere Variante nochmal... -
@crunchip Das war mein ursprünglicher Gedanke, aber ich hab das nicht hinbekommen mit Grafana. Ich logge jetzt einfach mal den Gesamtzähler mit. Wie müssen die Einstellungen in Grafana aussehen wenn ich den tageweisen Verbrauch anzeigen will?
@paul53, @Homoran , ich hab viel rum gespielt die letzte Zeit weil ich es nicht hinbekommen hab. Deswegen auch die Frage am Anfang ob man das so macht :-) Aber wenn crunchip sagt das es mit Grafana auch geht, wär mir das lieber ;-)
Mal sehen was er antwortet, wenn es nicht klappt dann versuche ich die andere Variante nochmal...@coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:
Ich logge jetzt einfach mal den Gesamtzähler mit. Wie müssen die Einstellungen in Grafana aussehen wenn ich den tageweisen Verbrauch anzeigen will?
Probier's mal (wenn Du influxDB 2 verwendest) so:
from(bucket: "influxdb") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "watermeter_m3") |> filter(fn: (r) => r["_field"] == "value") |> aggregateWindow(every: 1d, fn: last, createEmpty: false) |> difference()bucketundmeasurementmüsstest Du an Deine Werte anpassen -
@crunchip Das war mein ursprünglicher Gedanke, aber ich hab das nicht hinbekommen mit Grafana. Ich logge jetzt einfach mal den Gesamtzähler mit. Wie müssen die Einstellungen in Grafana aussehen wenn ich den tageweisen Verbrauch anzeigen will?
@paul53, @Homoran , ich hab viel rum gespielt die letzte Zeit weil ich es nicht hinbekommen hab. Deswegen auch die Frage am Anfang ob man das so macht :-) Aber wenn crunchip sagt das es mit Grafana auch geht, wär mir das lieber ;-)
Mal sehen was er antwortet, wenn es nicht klappt dann versuche ich die andere Variante nochmal...@coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:
Wie müssen die Einstellungen in Grafana aussehen
so wie gezeigt, ausser du verwendest keine influxdbV2
umgestiegen von Proxmox auf Unraid
-
@coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:
Wie müssen die Einstellungen in Grafana aussehen
so wie gezeigt, ausser du verwendest keine influxdbV2
-
@coachi ja klar, hier mal ein dashboard als Beispiel
{ "__inputs": [ { "name": "DS_INFLUXDB", "label": "InfluxDB", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "panel", "id": "gauge", "name": "Gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "10.0.3" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "description": "Wasserverbrauch", "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": null, "links": [ { "asDropdown": true, "icon": "external link", "includeVars": true, "keepTime": true, "tags": [ "Hausenergie" ], "targetBlank": false, "title": "Hausenergie", "tooltip": "", "type": "dashboards", "url": "" } ], "liveNow": false, "panels": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "custom": { "align": "right", "cellOptions": { "type": "auto" }, "filterable": false, "inspect": false }, "decimals": 3, "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "blue", "value": null }, { "color": "super-light-orange", "value": 0.1 }, { "color": "light-orange", "value": 0.2 }, { "color": "semi-dark-orange", "value": 0.4 }, { "color": "dark-red", "value": 0.8 } ] }, "unit": "m3" }, "overrides": [ { "matcher": { "id": "byName", "options": "Verbrauch" }, "properties": [ { "id": "custom.cellOptions", "value": { "mode": "gradient", "type": "gauge" } }, { "id": "custom.width", "value": 200 } ] }, { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:D.M.Y" }, { "id": "displayName", "value": "Tag" } ] } ] }, "gridPos": { "h": 29, "w": 5, "x": 0, "y": 0 }, "id": 4, "options": { "cellHeight": "sm", "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [] }, "pluginVersion": "10.0.3", "targets": [ { "alias": "Verbrauch", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_3", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "timeFrom": "1M", "title": "Wasserverbrauch", "transformations": [ { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "Time" } ] } } ], "transparent": true, "type": "table" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 3, "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "blue", "value": null }, { "color": "super-light-orange", "value": 0.07 }, { "color": "semi-dark-orange", "value": 0.14 }, { "color": "dark-orange", "value": 0.21 }, { "color": "dark-red", "value": 0.28 } ] }, "unit": "m3" }, "overrides": [] }, "gridPos": { "h": 6, "w": 8, "x": 5, "y": 0 }, "hideTimeOverride": true, "id": 6, "interval": "", "options": { "displayMode": "gradient", "minVizHeight": 10, "minVizWidth": 0, "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showUnfilled": true, "text": {}, "valueMode": "color" }, "pluginVersion": "10.0.3", "targets": [ { "alias": "Mo", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.01_Monday", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Di", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.02_Tuesday", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Mi", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.03_Wednesday", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Do", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.04_Thursday", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Fr", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.05_Friday", "orderByTime": "ASC", "policy": "default", "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Sa", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.06_Saturday", "orderByTime": "ASC", "policy": "default", "refId": "F", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "So", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.07_Sunday", "orderByTime": "ASC", "policy": "default", "refId": "G", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "timeFrom": "7d", "title": "Tagesverbrauch", "transparent": true, "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 13, "y": 0 }, "id": 10, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "10.0.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.02_currentWeek", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Woche", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "orange", "value": 9 }, { "color": "red", "value": 12 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 5, "w": 3, "x": 16, "y": 0 }, "id": 12, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": false }, "pluginVersion": "10.0.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.03_currentMonth", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Monat", "type": "gauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 3, "w": 5, "x": 19, "y": 0 }, "id": 14, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "10.0.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.05_currentYear", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Jahr", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "m³" }, "overrides": [] }, "gridPos": { "h": 2, "w": 5, "x": 19, "y": 3 }, "id": 16, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "10.0.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_3", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Zählerstand", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 100, "gradientMode": "opacity", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "line" } }, "links": [], "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null } ] }, "unit": "flowlpm" }, "overrides": [ { "matcher": { "id": "byName", "options": "Gesamt" }, "properties": [ { "id": "color", "value": { "fixedColor": "semi-dark-blue", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "solar" }, "properties": [ { "id": "color", "value": { "fixedColor": "#73BF69", "mode": "fixed" } }, { "id": "unit", "value": "watt" } ] } ] }, "gridPos": { "h": 10, "w": 19, "x": 5, "y": 6 }, "id": 8, "links": [], "options": { "legend": { "calcs": [ "mean", "lastNotNull", "max", "min" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.5.2", "targets": [ { "alias": "Gesamt", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "wiffi-wz.0.root.10_1_30_10.w_power_3", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ " *1000" ], "type": "math" } ] ], "tags": [] } ], "title": "aktueller Wasserverbrauch", "transparent": true, "type": "timeseries" } ], "refresh": "", "schemaVersion": 38, "style": "dark", "tags": [ "Hausenergie", "Wasser" ], "templating": { "list": [] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Wasser", "uid": "nZwcX6d4k", "version": 17, "weekStart": "" }umgestiegen von Proxmox auf Unraid
-
@coachi ja klar, hier mal ein dashboard als Beispiel
{ "__inputs": [ { "name": "DS_INFLUXDB", "label": "InfluxDB", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "panel", "id": "gauge", "name": "Gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "10.0.3" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "description": "Wasserverbrauch", "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": null, "links": [ { "asDropdown": true, "icon": "external link", "includeVars": true, "keepTime": true, "tags": [ "Hausenergie" ], "targetBlank": false, "title": "Hausenergie", "tooltip": "", "type": "dashboards", "url": "" } ], "liveNow": false, "panels": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "custom": { "align": "right", "cellOptions": { "type": "auto" }, "filterable": false, "inspect": false }, "decimals": 3, "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "blue", "value": null }, { "color": "super-light-orange", "value": 0.1 }, { "color": "light-orange", "value": 0.2 }, { "color": "semi-dark-orange", "value": 0.4 }, { "color": "dark-red", "value": 0.8 } ] }, "unit": "m3" }, "overrides": [ { "matcher": { "id": "byName", "options": "Verbrauch" }, "properties": [ { "id": "custom.cellOptions", "value": { "mode": "gradient", "type": "gauge" } }, { "id": "custom.width", "value": 200 } ] }, { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:D.M.Y" }, { "id": "displayName", "value": "Tag" } ] } ] }, "gridPos": { "h": 29, "w": 5, "x": 0, "y": 0 }, "id": 4, "options": { "cellHeight": "sm", "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [] }, "pluginVersion": "10.0.3", "targets": [ { "alias": "Verbrauch", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_3", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "timeFrom": "1M", "title": "Wasserverbrauch", "transformations": [ { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "Time" } ] } } ], "transparent": true, "type": "table" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 3, "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "blue", "value": null }, { "color": "super-light-orange", "value": 0.07 }, { "color": "semi-dark-orange", "value": 0.14 }, { "color": "dark-orange", "value": 0.21 }, { "color": "dark-red", "value": 0.28 } ] }, "unit": "m3" }, "overrides": [] }, "gridPos": { "h": 6, "w": 8, "x": 5, "y": 0 }, "hideTimeOverride": true, "id": 6, "interval": "", "options": { "displayMode": "gradient", "minVizHeight": 10, "minVizWidth": 0, "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showUnfilled": true, "text": {}, "valueMode": "color" }, "pluginVersion": "10.0.3", "targets": [ { "alias": "Mo", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.01_Monday", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Di", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.02_Tuesday", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Mi", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.03_Wednesday", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Do", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.04_Thursday", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Fr", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.05_Friday", "orderByTime": "ASC", "policy": "default", "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Sa", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.06_Saturday", "orderByTime": "ASC", "policy": "default", "refId": "F", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "So", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.07_Sunday", "orderByTime": "ASC", "policy": "default", "refId": "G", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "timeFrom": "7d", "title": "Tagesverbrauch", "transparent": true, "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 13, "y": 0 }, "id": 10, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "10.0.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.02_currentWeek", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Woche", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "orange", "value": 9 }, { "color": "red", "value": 12 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 5, "w": 3, "x": 16, "y": 0 }, "id": 12, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": false }, "pluginVersion": "10.0.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.03_currentMonth", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Monat", "type": "gauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 3, "w": 5, "x": 19, "y": 0 }, "id": 14, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "10.0.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.05_currentYear", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Jahr", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "m³" }, "overrides": [] }, "gridPos": { "h": 2, "w": 5, "x": 19, "y": 3 }, "id": 16, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "10.0.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_3", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Zählerstand", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 100, "gradientMode": "opacity", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "line" } }, "links": [], "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null } ] }, "unit": "flowlpm" }, "overrides": [ { "matcher": { "id": "byName", "options": "Gesamt" }, "properties": [ { "id": "color", "value": { "fixedColor": "semi-dark-blue", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "solar" }, "properties": [ { "id": "color", "value": { "fixedColor": "#73BF69", "mode": "fixed" } }, { "id": "unit", "value": "watt" } ] } ] }, "gridPos": { "h": 10, "w": 19, "x": 5, "y": 6 }, "id": 8, "links": [], "options": { "legend": { "calcs": [ "mean", "lastNotNull", "max", "min" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.5.2", "targets": [ { "alias": "Gesamt", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "wiffi-wz.0.root.10_1_30_10.w_power_3", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ " *1000" ], "type": "math" } ] ], "tags": [] } ], "title": "aktueller Wasserverbrauch", "transparent": true, "type": "timeseries" } ], "refresh": "", "schemaVersion": 38, "style": "dark", "tags": [ "Hausenergie", "Wasser" ], "templating": { "list": [] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Wasser", "uid": "nZwcX6d4k", "version": 17, "weekStart": "" }@crunchip Hab jetzt seit paar Tagen den Gesamtverbrauch geloggt. Seitdem schauts ganz gut aus. An Grafana hats nicht gelegen, sondern eher daran das ich den Tagesverbrauch als Wert genommen hab und nicht den Gesamtverbrauch. Muss noch paar Tage warten aber Stand jetzt passt es ;-)