Wasserverbrauch tageweise loggen und anzeigen

[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