Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Off Topic
    4. Grafana
    5. Tagesverbrauch Wasser

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

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

    • ioBroker goes Matter ... Matter Adapter in Stable

    Tagesverbrauch Wasser

    This topic has been deleted. Only users with topic management privileges can see it.
    • F
      FK757 @crunchip last edited by

      @crunchip
      Die Auswertung erfolgt über Fotos die gemacht werden vom Zähler und das AI-on-the-edge wertet die Zeigerstellungen aus und gibt sie als Zahl dann aus.
      Ja ich habe einen Gesamtzählerstand den ich auch in die InfluxDB speichere.
      Nur habe ich in Grafana dann nur eine langsam Ansteigene Linie was eigendlich als Auswertung nicht viel sinn macht.
      Wie geht das den das ich in Grafana mir Tagesverbrauchsbalken erstellen lassen kann ?

      crunchip 1 Reply Last reply Reply Quote 0
      • F
        FK757 @Codierknecht last edited by

        @codierknecht
        So heute Morgen mal nachgeschaut was für Werte geschrieben wurden aber es scheint noch was nicht zu stimmen.
        Anscheinend hat wohl genau zu zum Zeitpunkt des Zeitplans die Auswertung einen falschen wert ausgegeben.
        005f2fb9-6363-49bd-b53b-8e4048dbb232-grafik.png
        Aber es wurde garkein wert in den Tagesverbrauch geschrieben ? das verstehe ich nicht ganz.
        Das Blockly habe ich eigendlich wie deins nachgebaut.
        5eff9aff-c266-4a56-9ff2-b54089be107f-grafik.png
        Mal schauen was es Morgen für werte liefert.

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

          @fk757 nutzt du Influx in Version 1.x oder 2.x
          Bei Version 2 muss dir jemand anders helfen, gibt aber hier im Forum einige Beispiele für den Code

          W F 2 Replies Last reply Reply Quote 0
          • David G.
            David G. last edited by

            Wenn man den Verbrauch schon erfasst, kann man sich doch noch ein paar mehr Statistiken besorgen und Source Analytics verwenden. Dort bekommt man dann auch seinen Wert mit dem Vortragesverbrauch und für Monate, Jahre etc.... .

            F 1 Reply Last reply Reply Quote 0
            • W
              wolfi913 @crunchip last edited by wolfi913

              @crunchip sagte in Tagesverbrauch Wasser:

              Bei Version 2 muss dir jemand anders helfen, gibt aber hier im Forum einige Beispiele für den Code

              @FK757 könnte so z.B. für den Tagesverbrauch mit V2 funktionieren, bucketund measurementmüssten noch an Deine Daten angepasst werden

              Wenn die Tageswerte in infuxDB vorliegen sollten

              import "timezone"
              import "date"
              option location = timezone.location(name: "Europe/Berlin")
              
              stoppoint = date.truncate(t: now(), unit: 1d)
              
              from(bucket: "influxdb")
                |> range(start: v.timeRangeStart, stop: stoppoint)
                |> filter(fn: (r) => r["_measurement"] == "kg_pellets_day")
                |> filter(fn: (r) => r["_field"] == "value")
                |> aggregateWindow(every: 1d, fn: max, createEmpty: false)
              

              Wenn ein Gesamtzählerstand vorliegt noch folgendes ergänzen

                |> difference()
              
              1 Reply Last reply Reply Quote 0
              • W
                wolfi913 @FK757 last edited by wolfi913

                @fk757 sagte in Tagesverbrauch Wasser:

                Aber es wurde garkein wert in den Tagesverbrauch geschrieben ? das verstehe ich nicht ganz.

                Leg den Trigger (und somit auch den Wert auf value, nicht auf raw. Dann sollte es funktionieren
                Screenshot 2024-04-28 095459.png

                PS: Und nimm den Trigger für den Zeitplan nicht in den Trigger für die Änderung. Sondern wie von @Codierknecht gezeigt darunter

                F 1 Reply Last reply Reply Quote 0
                • F
                  FK757 @crunchip last edited by

                  @crunchip said in Tagesverbrauch Wasser:
                  Benutze Influx in Version 1.x

                  crunchip 1 Reply Last reply Reply Quote 0
                  • F
                    FK757 @David G. last edited by

                    @david-g said in Tagesverbrauch Wasser:
                    Danke für den Hinweis kenne ich noch nicht werde es mal Ausprobieren.

                    1 Reply Last reply Reply Quote 0
                    • F
                      FK757 @wolfi913 last edited by

                      @wolfi913
                      Brauche langsam doch eine Brille 🤦‍♂️
                      a38054a7-e562-4dce-8697-64cfd62c01d7-grafik.png
                      Danke für den Hinweiß

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

                        @fk757 hier mal ein Dashboard zum einfügen in Grafana, deinen Datenpunkt Gesamt musst du entsprechend einfügen.

                        {
                          "__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": [],
                                  "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": [],
                                  "thresholds": {
                                    "mode": "absolute",
                                    "steps": [
                                      {
                                        "color": "blue",
                                        "value": null
                                      },
                                      {
                                        "color": "super-light-orange",
                                        "value": 3
                                      },
                                      {
                                        "color": "semi-dark-orange",
                                        "value": 6
                                      },
                                      {
                                        "color": "dark-orange",
                                        "value": 9
                                      },
                                      {
                                        "color": "dark-red",
                                        "value": 12
                                      }
                                    ]
                                  },
                                  "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": 7
                                      },
                                      {
                                        "color": "red",
                                        "value": 9
                                      }
                                    ]
                                  },
                                  "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-24h",
                            "to": "now"
                          },
                          "timepicker": {},
                          "timezone": "",
                          "title": "Wasser",
                          "uid": "nZwcX6d4k",
                          "version": 14,
                          "weekStart": ""
                        }
                        

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

                        Support us

                        ioBroker
                        Community Adapters
                        Donate

                        822
                        Online

                        31.9k
                        Users

                        80.1k
                        Topics

                        1.3m
                        Posts

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