Skip to content
  • Home
  • Aktuell
  • Tags
  • 0 Ungelesen 0
  • Kategorien
  • Unreplied
  • Beliebt
  • GitHub
  • Docu
  • Hilfe
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Standard: (Kein Skin)
  • Kein Skin
Einklappen
ioBroker Logo

Community Forum

donate donate
  1. ioBroker Community Home
  2. Deutsch
  3. Skripten / Logik
  4. Blockly
  5. Wasserverbrauch tageweise loggen und anzeigen

NEWS

  • Jahresrückblick 2025 – unser neuer Blogbeitrag ist online! ✨
    BluefoxB
    Bluefox
    17
    1
    4.0k

  • Neuer Blogbeitrag: Monatsrückblick - Dezember 2025 🎄
    BluefoxB
    Bluefox
    13
    1
    1.2k

  • Weihnachtsangebot 2025! 🎄
    BluefoxB
    Bluefox
    25
    1
    2.5k

Wasserverbrauch tageweise loggen und anzeigen

Geplant Angeheftet Gesperrt Verschoben Blockly
19 Beiträge 5 Kommentatoren 1.1k Aufrufe 4 Watching
  • Älteste zuerst
  • Neuste zuerst
  • Meiste Stimmen
Antworten
  • In einem neuen Thema antworten
Anmelden zum Antworten
Dieses Thema wurde gelöscht. Nur Nutzer mit entsprechenden Rechten können es sehen.
  • paul53P 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:

    Blockly_temp.JPG

    HomoranH Nicht stören
    HomoranH Nicht stören
    Homoran
    Global Moderator Administrators
    schrieb am zuletzt editiert von
    #10

    @paul53 sagte in Wasserverbrauch tageweise loggen und anzeigen:

    Ich komme mit den Datenpunktnamen und Variablenbezeichnern nicht zurecht.

    ich bin davon ausgegangen dass es irgendwo schon etwas gibt, dass den heutigen Verbrauch kumuliert und in den triggernden DP schreibt

    kein Support per PN! - Fragen im Forum stellen - es gibt fast nichts, was nicht auch für andere interessant ist.

    Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.

    der Installationsfixer: curl -fsL https://iobroker.net/fix.sh | bash -

    paul53P 1 Antwort Letzte Antwort
    0
    • HomoranH 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

      paul53P Offline
      paul53P Offline
      paul53
      schrieb am zuletzt editiert von
      #11

      @homoran sagte: etwas gibt, dass den heutigen Verbrauch kumuliert und in den triggernden DP schreibt

      Dann ist aber in dem Skript "Wasser_Zählerstand_gestern" = "Verbrauch_heute" um 23:59 Uhr. Das passt von den Namen her nicht.

      Bitte verzichtet auf Chat-Nachrichten, denn die Handhabung ist grauenhaft !
      Produktiv: RPi 2 mit S.USV, HM-MOD-RPI und SLC-USB-Stick mit root fs

      HomoranH 1 Antwort Letzte Antwort
      0
      • paul53P 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.

        HomoranH Nicht stören
        HomoranH Nicht stören
        Homoran
        Global Moderator Administrators
        schrieb am zuletzt editiert von
        #12

        @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

        kein Support per PN! - Fragen im Forum stellen - es gibt fast nichts, was nicht auch für andere interessant ist.

        Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.

        der Installationsfixer: curl -fsL https://iobroker.net/fix.sh | bash -

        1 Antwort Letzte Antwort
        0
        • C Coachi

          Hallo,
          ich versuche gerade mit iobroker und Blockly meinen Wasserverbrauch tageweise zu loggen und mit Grafana darzustellen.
          Folgendes Blockly hab ich erstellt:
          Unbenannt.JPG

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

          Unbena1nnt.JPG

          Ist das so wie ich das versuche möglich?

          Viele Grüße

          crunchipC Abwesend
          crunchipC Abwesend
          crunchip
          Forum Testing Most Active
          schrieb am zuletzt editiert von
          #13

          @coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:

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

          Das kannst du mit Grafana, dazu benötigst du nicht jeden Tag, sondern nur deinen Gesamtzählerstand, den Rest macht Grafana

          umgestiegen von Proxmox auf Unraid

          C 1 Antwort Letzte Antwort
          0
          • crunchipC 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

            C Offline
            C Offline
            Coachi
            schrieb am zuletzt editiert von
            #14

            @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 crunchipC 2 Antworten Letzte Antwort
            0
            • C 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...

              W Online
              W Online
              wolfi913
              schrieb am zuletzt editiert von wolfi913
              #15

              @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 Antwort Letzte Antwort
              0
              • C 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...

                crunchipC Abwesend
                crunchipC Abwesend
                crunchip
                Forum Testing Most Active
                schrieb am zuletzt editiert von
                #16

                @coachi sagte in Wasserverbrauch tageweise loggen und anzeigen:

                Wie müssen die Einstellungen in Grafana aussehen

                so wie gezeigt, ausser du verwendest keine influxdbV2

                umgestiegen von Proxmox auf Unraid

                C 1 Antwort Letzte Antwort
                0
                • crunchipC 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

                  C Offline
                  C Offline
                  Coachi
                  schrieb am zuletzt editiert von
                  #17

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

                  1 Antwort Letzte Antwort
                  0
                  • crunchipC Abwesend
                    crunchipC Abwesend
                    crunchip
                    Forum Testing Most Active
                    schrieb am zuletzt editiert von
                    #18

                    @coachi ja klar, hier mal ein dashboard als Beispiel

                    {
                     "__inputs": [
                       {
                         "name": "DS_INFLUXDB",
                         "label": "InfluxDB",
                         "description": "",
                         "type": "datasource",
                         "pluginId": "influxdb",
                         "pluginName": "InfluxDB"
                       }
                     ],
                     "__elements": {},
                     "__requires": [
                       {
                         "type": "panel",
                         "id": "bargauge",
                         "name": "Bar gauge",
                         "version": ""
                       },
                       {
                         "type": "panel",
                         "id": "gauge",
                         "name": "Gauge",
                         "version": ""
                       },
                       {
                         "type": "grafana",
                         "id": "grafana",
                         "name": "Grafana",
                         "version": "10.0.3"
                       },
                       {
                         "type": "datasource",
                         "id": "influxdb",
                         "name": "InfluxDB",
                         "version": "1.0.0"
                       },
                       {
                         "type": "panel",
                         "id": "stat",
                         "name": "Stat",
                         "version": ""
                       },
                       {
                         "type": "panel",
                         "id": "table",
                         "name": "Table",
                         "version": ""
                       },
                       {
                         "type": "panel",
                         "id": "timeseries",
                         "name": "Time series",
                         "version": ""
                       }
                     ],
                     "annotations": {
                       "list": [
                         {
                           "builtIn": 1,
                           "datasource": {
                             "type": "grafana",
                             "uid": "-- Grafana --"
                           },
                           "enable": true,
                           "hide": true,
                           "iconColor": "rgba(0, 211, 255, 1)",
                           "name": "Annotations & Alerts",
                           "target": {
                             "limit": 100,
                             "matchAny": false,
                             "tags": [],
                             "type": "dashboard"
                           },
                           "type": "dashboard"
                         }
                       ]
                     },
                     "description": "Wasserverbrauch",
                     "editable": true,
                     "fiscalYearStartMonth": 0,
                     "graphTooltip": 0,
                     "id": null,
                     "links": [
                       {
                         "asDropdown": true,
                         "icon": "external link",
                         "includeVars": true,
                         "keepTime": true,
                         "tags": [
                           "Hausenergie"
                         ],
                         "targetBlank": false,
                         "title": "Hausenergie",
                         "tooltip": "",
                         "type": "dashboards",
                         "url": ""
                       }
                     ],
                     "liveNow": false,
                     "panels": [
                       {
                         "datasource": {
                           "type": "influxdb",
                           "uid": "${DS_INFLUXDB}"
                         },
                         "fieldConfig": {
                           "defaults": {
                             "custom": {
                               "align": "right",
                               "cellOptions": {
                                 "type": "auto"
                               },
                               "filterable": false,
                               "inspect": false
                             },
                             "decimals": 3,
                             "mappings": [],
                             "min": 0,
                             "thresholds": {
                               "mode": "absolute",
                               "steps": [
                                 {
                                   "color": "blue",
                                   "value": null
                                 },
                                 {
                                   "color": "super-light-orange",
                                   "value": 0.1
                                 },
                                 {
                                   "color": "light-orange",
                                   "value": 0.2
                                 },
                                 {
                                   "color": "semi-dark-orange",
                                   "value": 0.4
                                 },
                                 {
                                   "color": "dark-red",
                                   "value": 0.8
                                 }
                               ]
                             },
                             "unit": "m3"
                           },
                           "overrides": [
                             {
                               "matcher": {
                                 "id": "byName",
                                 "options": "Verbrauch"
                               },
                               "properties": [
                                 {
                                   "id": "custom.cellOptions",
                                   "value": {
                                     "mode": "gradient",
                                     "type": "gauge"
                                   }
                                 },
                                 {
                                   "id": "custom.width",
                                   "value": 200
                                 }
                               ]
                             },
                             {
                               "matcher": {
                                 "id": "byName",
                                 "options": "Time"
                               },
                               "properties": [
                                 {
                                   "id": "unit",
                                   "value": "time:D.M.Y"
                                 },
                                 {
                                   "id": "displayName",
                                   "value": "Tag"
                                 }
                               ]
                             }
                           ]
                         },
                         "gridPos": {
                           "h": 29,
                           "w": 5,
                           "x": 0,
                           "y": 0
                         },
                         "id": 4,
                         "options": {
                           "cellHeight": "sm",
                           "footer": {
                             "countRows": false,
                             "fields": "",
                             "reducer": [
                               "sum"
                             ],
                             "show": false
                           },
                           "showHeader": true,
                           "sortBy": []
                         },
                         "pluginVersion": "10.0.3",
                         "targets": [
                           {
                             "alias": "Verbrauch",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "1d"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "previous"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_3",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "A",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "last"
                                 },
                                 {
                                   "params": [],
                                   "type": "difference"
                                 }
                               ]
                             ],
                             "tags": []
                           }
                         ],
                         "timeFrom": "1M",
                         "title": "Wasserverbrauch",
                         "transformations": [
                           {
                             "id": "sortBy",
                             "options": {
                               "fields": {},
                               "sort": [
                                 {
                                   "desc": true,
                                   "field": "Time"
                                 }
                               ]
                             }
                           }
                         ],
                         "transparent": true,
                         "type": "table"
                       },
                       {
                         "datasource": {
                           "type": "influxdb",
                           "uid": "${DS_INFLUXDB}"
                         },
                         "fieldConfig": {
                           "defaults": {
                             "color": {
                               "mode": "thresholds"
                             },
                             "decimals": 3,
                             "mappings": [],
                             "min": 0,
                             "thresholds": {
                               "mode": "absolute",
                               "steps": [
                                 {
                                   "color": "blue",
                                   "value": null
                                 },
                                 {
                                   "color": "super-light-orange",
                                   "value": 0.07
                                 },
                                 {
                                   "color": "semi-dark-orange",
                                   "value": 0.14
                                 },
                                 {
                                   "color": "dark-orange",
                                   "value": 0.21
                                 },
                                 {
                                   "color": "dark-red",
                                   "value": 0.28
                                 }
                               ]
                             },
                             "unit": "m3"
                           },
                           "overrides": []
                         },
                         "gridPos": {
                           "h": 6,
                           "w": 8,
                           "x": 5,
                           "y": 0
                         },
                         "hideTimeOverride": true,
                         "id": 6,
                         "interval": "",
                         "options": {
                           "displayMode": "gradient",
                           "minVizHeight": 10,
                           "minVizWidth": 0,
                           "orientation": "auto",
                           "reduceOptions": {
                             "calcs": [
                               "lastNotNull"
                             ],
                             "fields": "",
                             "values": false
                           },
                           "showUnfilled": true,
                           "text": {},
                           "valueMode": "color"
                         },
                         "pluginVersion": "10.0.3",
                         "targets": [
                           {
                             "alias": "Mo",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.01_Monday",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "A",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           },
                           {
                             "alias": "Di",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.02_Tuesday",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "B",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           },
                           {
                             "alias": "Mi",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.03_Wednesday",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "C",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           },
                           {
                             "alias": "Do",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.04_Thursday",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "D",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           },
                           {
                             "alias": "Fr",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.05_Friday",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "E",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           },
                           {
                             "alias": "Sa",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.06_Saturday",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "F",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           },
                           {
                             "alias": "So",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.consumed.currentWeek.07_Sunday",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "G",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           }
                         ],
                         "timeFrom": "7d",
                         "title": "Tagesverbrauch",
                         "transparent": true,
                         "type": "bargauge"
                       },
                       {
                         "datasource": {
                           "type": "influxdb",
                           "uid": "${DS_INFLUXDB}"
                         },
                         "fieldConfig": {
                           "defaults": {
                             "mappings": [],
                             "thresholds": {
                               "mode": "absolute",
                               "steps": [
                                 {
                                   "color": "green",
                                   "value": null
                                 },
                                 {
                                   "color": "red",
                                   "value": 80
                                 }
                               ]
                             },
                             "unit": "currencyEUR"
                           },
                           "overrides": []
                         },
                         "gridPos": {
                           "h": 4,
                           "w": 3,
                           "x": 13,
                           "y": 0
                         },
                         "id": 10,
                         "options": {
                           "colorMode": "none",
                           "graphMode": "area",
                           "justifyMode": "auto",
                           "orientation": "auto",
                           "reduceOptions": {
                             "calcs": [
                               "lastNotNull"
                             ],
                             "fields": "",
                             "values": false
                           },
                           "textMode": "auto"
                         },
                         "pluginVersion": "10.0.3",
                         "targets": [
                           {
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.02_currentWeek",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "A",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           }
                         ],
                         "title": "Woche",
                         "type": "stat"
                       },
                       {
                         "datasource": {
                           "type": "influxdb",
                           "uid": "${DS_INFLUXDB}"
                         },
                         "fieldConfig": {
                           "defaults": {
                             "mappings": [],
                             "thresholds": {
                               "mode": "absolute",
                               "steps": [
                                 {
                                   "color": "green",
                                   "value": null
                                 },
                                 {
                                   "color": "orange",
                                   "value": 9
                                 },
                                 {
                                   "color": "red",
                                   "value": 12
                                 }
                               ]
                             },
                             "unit": "currencyEUR"
                           },
                           "overrides": []
                         },
                         "gridPos": {
                           "h": 5,
                           "w": 3,
                           "x": 16,
                           "y": 0
                         },
                         "id": 12,
                         "options": {
                           "orientation": "auto",
                           "reduceOptions": {
                             "calcs": [
                               "lastNotNull"
                             ],
                             "fields": "",
                             "values": false
                           },
                           "showThresholdLabels": false,
                           "showThresholdMarkers": false
                         },
                         "pluginVersion": "10.0.3",
                         "targets": [
                           {
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.03_currentMonth",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "A",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           }
                         ],
                         "title": "Monat",
                         "type": "gauge"
                       },
                       {
                         "datasource": {
                           "type": "influxdb",
                           "uid": "${DS_INFLUXDB}"
                         },
                         "fieldConfig": {
                           "defaults": {
                             "mappings": [],
                             "thresholds": {
                               "mode": "absolute",
                               "steps": [
                                 {
                                   "color": "green",
                                   "value": null
                                 },
                                 {
                                   "color": "red",
                                   "value": 80
                                 }
                               ]
                             },
                             "unit": "currencyEUR"
                           },
                           "overrides": []
                         },
                         "gridPos": {
                           "h": 3,
                           "w": 5,
                           "x": 19,
                           "y": 0
                         },
                         "id": 14,
                         "options": {
                           "colorMode": "none",
                           "graphMode": "area",
                           "justifyMode": "auto",
                           "orientation": "auto",
                           "reduceOptions": {
                             "calcs": [
                               "lastNotNull"
                             ],
                             "fields": "",
                             "values": false
                           },
                           "textMode": "auto"
                         },
                         "pluginVersion": "10.0.3",
                         "targets": [
                           {
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_3.currentYear.costs.05_currentYear",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "A",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           }
                         ],
                         "title": "Jahr",
                         "type": "stat"
                       },
                       {
                         "datasource": {
                           "type": "influxdb",
                           "uid": "${DS_INFLUXDB}"
                         },
                         "fieldConfig": {
                           "defaults": {
                             "mappings": [],
                             "thresholds": {
                               "mode": "absolute",
                               "steps": [
                                 {
                                   "color": "green",
                                   "value": null
                                 },
                                 {
                                   "color": "red",
                                   "value": 80
                                 }
                               ]
                             },
                             "unit": "m³"
                           },
                           "overrides": []
                         },
                         "gridPos": {
                           "h": 2,
                           "w": 5,
                           "x": 19,
                           "y": 3
                         },
                         "id": 16,
                         "options": {
                           "colorMode": "none",
                           "graphMode": "none",
                           "justifyMode": "auto",
                           "orientation": "auto",
                           "reduceOptions": {
                             "calcs": [
                               "lastNotNull"
                             ],
                             "fields": "",
                             "values": false
                           },
                           "textMode": "auto"
                         },
                         "pluginVersion": "10.0.3",
                         "targets": [
                           {
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "$__interval"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "null"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_3",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "A",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 }
                               ]
                             ],
                             "tags": []
                           }
                         ],
                         "title": "Zählerstand",
                         "type": "stat"
                       },
                       {
                         "datasource": {
                           "type": "influxdb",
                           "uid": "${DS_INFLUXDB}"
                         },
                         "fieldConfig": {
                           "defaults": {
                             "color": {
                               "mode": "palette-classic"
                             },
                             "custom": {
                               "axisCenteredZero": false,
                               "axisColorMode": "text",
                               "axisLabel": "",
                               "axisPlacement": "auto",
                               "barAlignment": 0,
                               "drawStyle": "line",
                               "fillOpacity": 100,
                               "gradientMode": "opacity",
                               "hideFrom": {
                                 "legend": false,
                                 "tooltip": false,
                                 "viz": false
                               },
                               "lineInterpolation": "linear",
                               "lineWidth": 1,
                               "pointSize": 5,
                               "scaleDistribution": {
                                 "type": "linear"
                               },
                               "showPoints": "never",
                               "spanNulls": false,
                               "stacking": {
                                 "group": "A",
                                 "mode": "none"
                               },
                               "thresholdsStyle": {
                                 "mode": "line"
                               }
                             },
                             "links": [],
                             "mappings": [],
                             "thresholds": {
                               "mode": "absolute",
                               "steps": [
                                 {
                                   "color": "transparent",
                                   "value": null
                                 }
                               ]
                             },
                             "unit": "flowlpm"
                           },
                           "overrides": [
                             {
                               "matcher": {
                                 "id": "byName",
                                 "options": "Gesamt"
                               },
                               "properties": [
                                 {
                                   "id": "color",
                                   "value": {
                                     "fixedColor": "semi-dark-blue",
                                     "mode": "fixed"
                                   }
                                 }
                               ]
                             },
                             {
                               "matcher": {
                                 "id": "byName",
                                 "options": "solar"
                               },
                               "properties": [
                                 {
                                   "id": "color",
                                   "value": {
                                     "fixedColor": "#73BF69",
                                     "mode": "fixed"
                                   }
                                 },
                                 {
                                   "id": "unit",
                                   "value": "watt"
                                 }
                               ]
                             }
                           ]
                         },
                         "gridPos": {
                           "h": 10,
                           "w": 19,
                           "x": 5,
                           "y": 6
                         },
                         "id": 8,
                         "links": [],
                         "options": {
                           "legend": {
                             "calcs": [
                               "mean",
                               "lastNotNull",
                               "max",
                               "min"
                             ],
                             "displayMode": "table",
                             "placement": "bottom",
                             "showLegend": true
                           },
                           "tooltip": {
                             "mode": "multi",
                             "sort": "none"
                           }
                         },
                         "pluginVersion": "8.5.2",
                         "targets": [
                           {
                             "alias": "Gesamt",
                             "datasource": {
                               "type": "influxdb",
                               "uid": "${DS_INFLUXDB}"
                             },
                             "groupBy": [
                               {
                                 "params": [
                                   "10s"
                                 ],
                                 "type": "time"
                               },
                               {
                                 "params": [
                                   "previous"
                                 ],
                                 "type": "fill"
                               }
                             ],
                             "hide": false,
                             "measurement": "wiffi-wz.0.root.10_1_30_10.w_power_3",
                             "orderByTime": "ASC",
                             "policy": "default",
                             "refId": "A",
                             "resultFormat": "time_series",
                             "select": [
                               [
                                 {
                                   "params": [
                                     "value"
                                   ],
                                   "type": "field"
                                 },
                                 {
                                   "params": [],
                                   "type": "mean"
                                 },
                                 {
                                   "params": [
                                     " *1000"
                                   ],
                                   "type": "math"
                                 }
                               ]
                             ],
                             "tags": []
                           }
                         ],
                         "title": "aktueller Wasserverbrauch",
                         "transparent": true,
                         "type": "timeseries"
                       }
                     ],
                     "refresh": "",
                     "schemaVersion": 38,
                     "style": "dark",
                     "tags": [
                       "Hausenergie",
                       "Wasser"
                     ],
                     "templating": {
                       "list": []
                     },
                     "time": {
                       "from": "now-6h",
                       "to": "now"
                     },
                     "timepicker": {},
                     "timezone": "",
                     "title": "Wasser",
                     "uid": "nZwcX6d4k",
                     "version": 17,
                     "weekStart": ""
                    }
                    

                    umgestiegen von Proxmox auf Unraid

                    C 1 Antwort Letzte Antwort
                    0
                    • crunchipC crunchip

                      @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 Offline
                      C Offline
                      Coachi
                      schrieb am zuletzt editiert von
                      #19

                      @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 Antwort Letzte Antwort
                      0
                      Antworten
                      • In einem neuen Thema antworten
                      Anmelden zum Antworten
                      • Älteste zuerst
                      • Neuste zuerst
                      • Meiste Stimmen


                      Support us

                      ioBroker
                      Community Adapters
                      Donate

                      565

                      Online

                      32.7k

                      Benutzer

                      82.4k

                      Themen

                      1.3m

                      Beiträge
                      Community
                      Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen | Einwilligungseinstellungen
                      ioBroker Community 2014-2025
                      logo
                      • Anmelden

                      • Du hast noch kein Konto? Registrieren

                      • Anmelden oder registrieren, um zu suchen
                      • Erster Beitrag
                        Letzter Beitrag
                      0
                      • Home
                      • Aktuell
                      • Tags
                      • Ungelesen 0
                      • Kategorien
                      • Unreplied
                      • Beliebt
                      • GitHub
                      • Docu
                      • Hilfe