Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Skripten / Logik
    4. Blockly
    5. Wasserverbrauch tageweise loggen und anzeigen

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    Wasserverbrauch tageweise loggen und anzeigen

    This topic has been deleted. Only users with topic management privileges can see it.
    • Homoran
      Homoran Global Moderator Administrators @paul53 last edited by

      @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 1 Reply Last reply Reply Quote 0
      • paul53
        paul53 @Homoran last edited by

        @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 1 Reply Last reply Reply Quote 0
        • Homoran
          Homoran Global Moderator Administrators @paul53 last edited by

          @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

          1 Reply Last reply Reply Quote 0
          • crunchip
            crunchip Forum Testing Most Active @Coachi last edited by

            @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

            C 1 Reply Last reply Reply Quote 0
            • C
              Coachi @crunchip last edited by

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

              W crunchip 2 Replies Last reply Reply Quote 0
              • W
                wolfi913 @Coachi last edited by 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

                1 Reply Last reply Reply Quote 0
                • crunchip
                  crunchip Forum Testing Most Active @Coachi last edited by

                  @coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:

                  Wie müssen die Einstellungen in Grafana aussehen

                  so wie gezeigt, ausser du verwendest keine influxdbV2

                  C 1 Reply Last reply Reply Quote 0
                  • C
                    Coachi @crunchip last edited by

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

                    1 Reply Last reply Reply Quote 0
                    • crunchip
                      crunchip Forum Testing Most Active last edited by

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

                      C 1 Reply Last reply Reply Quote 0
                      • C
                        Coachi @crunchip last edited by

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

                        1 Reply Last reply Reply Quote 0
                        • First post
                          Last post

                        Support us

                        ioBroker
                        Community Adapters
                        Donate

                        890
                        Online

                        31.9k
                        Users

                        80.2k
                        Topics

                        1.3m
                        Posts

                        5
                        19
                        499
                        Loading More Posts
                        • Oldest to Newest
                        • Newest to Oldest
                        • Most Votes
                        Reply
                        • Reply as topic
                        Log in to reply
                        Community
                        Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                        The ioBroker Community 2014-2023
                        logo