Wasserverbrauch tageweise loggen und anzeigen

[Homoran]

@coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:

Aber aktuell wird nichts in den DP geschrieben,

das ist natürlich Bedingung

[Homoran]

@coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:

Die Frage ist ob ich komplett daneben liege oder ob es so gehen könnte

das ist die übliche Vorgehensweise

[paul53]

@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:

[Homoran]

@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

[paul53]

@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.

[Homoran]

@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 gestern

[crunchip]

@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

[Coachi]

@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...

[wolfi913]

@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()

bucket und measurement müsstest Du an Deine Werte anpassen

[crunchip]

@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]

@crunchip Ich verwende influxdb, also noch nicht die neue Version. Gehts damit auch?

[crunchip]

@coachi ja klar, hier mal ein dashboard als Beispiel

Spoiler

{
 "__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": ""
}

[Coachi]

@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