NEWS

@agrippinenser sagte in Grafana > transparenter Hintergrund:

Feinstaub: dieses > HmIP-SFD

ja! (als Bausatz)

@agrippinenser sagte in Grafana > transparenter Hintergrund:

Wetter: HmIP-SWO-B oder sogar HmIP-SWO-PR ?

weder noch! Sondern eine 12 Jahre alte HomeMatic Wetterstation.

Problem gefunden:
In den sogenanntem Label des Alerts müssen Variablen eingetragen werden: zb. Router = Asus
Diese Variablen müssen dann in den Benachrichtigungsrichtlinien unter "New nested policy" ebenfalls eingetragen werden.

Unbenannt1.jpg
Unbenannt.jpg

Trotzdem herzlichen Dank!

@domm

Also ich hab jetzt noch zweimal drübergelesen, aber ich hab immernoch nicht wirklich verstanden wo dein Problem liegt.
Vielleicht solltest du mal ein Bild vom Grafana Dashboard zeigen und was du genau machen möchtest.

Wenn du schreibst du hast alle DP vorliegen und schreibst diese auch in die InfluxDB, dann mußt du die doch nur noch abfragen, bzw eine vorhandene Abfrage anpassen.
Dann in Grafana das Dashboard aufrufen und eine neue Visualisierung hinzufügen.

@andi_grafa sagte in Grafana, Summierung der letzten Tageswerte:

Wie du schon richtig selbst festgestellt hast, summierst du stumpf ALLE Werte. Stattdessen willst du ja nur den jeweilig letzten Wert des Tages nehmen und den im Monat summieren. Das bedeutet, dass du noch ein zusätzliches "aggregateWindow" benötigt, mit dem du den Tages"letzt"wert ermittelst. Versuchs mal so:

import "timezone" import "date" option location = timezone.location(name: "Europe/Berlin") from(bucket: "iobroker") |> range(start: date.truncate(t: date.add(d: -6mo, to: today()), unit: 1mo), stop: date.truncate(t: today(), unit: 1mo)) |> filter(fn: (r) => r["_measurement"] == "Regen heute") |> filter(fn: (r) => r["_field"] == "value") |> aggregateWindow(every: 1d, fn: last, createEmpty: true, timeSrc: "_start") |> aggregateWindow(every: 1mo, fn: sum, createEmpty: true, timeSrc: "_start")

@meister-mopper Danke 👍

@crunchip vielen dank, das hätte ich nie gefunden.

@mere13 sagte in Tagesverbrauch - Ich komm nicht drauf:

|> aggregateWindow(every: 24h, fn: last, timeSrc: "_start", createEmpty: false)

Würde stattdessen mal every: 1d testen. Sonst werden wahrscheinlich immer nur 24 Stunden genommen und die Tagesgrenze ignoriert.

Ich würde vor dem aggregateWindow die Differenz bilden und dann sum aller Differenzen anwenden.

import "timezone" option location = timezone.location(name: "Europe/Berlin") from(bucket: "homebucket") |> range(start: -10d) |> filter(fn: (r) => r["_measurement"] == "mystrom energy since boot - WLAN" and r["_field"] == "value") |> difference(nonNegative: true, columns: ["_value"]) |> aggregateWindow(every: 1d, fn: sum, timeSrc: "_start", createEmpty: false) |> map(fn: (r) => ({r with _value: r._value / 3600.0})) |> yield(name: "last")

siehe hier: https://forum.iobroker.net/post/1166370

@udbruegg
Ich hab es !
Entschuldigt diese halbgare Aktion. Ich war echt etwas in Panik, weil ich da echt schon einige Tage Arbeit drin habe.
Es war das einfache einloggen. Ich hatte nur was mit den Passwörtern "damals" nicht eindeutig dokumentiert und war nun total auf dem irrem Holzweg.
Sorry...
Ist mir echt etwas peinlich, dass ich bei so einer einfachen Sache, so panisch in die falsche Richtung gerannt bin.

Hallo PB74,

da habe ich länger dran gesessen 🙂

Schritt für Schritt:

In der Instanz:
abbf88b6-a300-4b7a-a610-910542123a98-grafik.png

Anschließend in Grafana

SELECT mean("value") FROM "pvforecast.0.summary.power" WHERE $timeFilter GROUP BY time($__interval) fill(linear)

cc2d3ff8-ea12-4b57-9bbd-7f18a9fd668c-grafik.png

Sollte klappen

Danke für die Unterstützung, da bei dem Datenpunkt keine ständigen Daten kommen, geht das so. Hab bei einem anderen, der ständig die Wertewechsel, da geht das so nicht. Daher erst mal Dankeschön, hier war es genau das richtig, was Ihr mir gesagt habt.

@luckyheiko

c3f6fee3-33b6-432b-95d3-cd097e8949ef-image.png

Fertig! Naja, der grobe Entwurf.
Wichtig ist, dass die Werte mit >Influx1.8 vorliegen. mit folgender Syntax kannst du die Daten umbiegen:

from(bucket: "Solar")
|> range(start: 12h, stop: 36h)
|> timeShift (duration: -48h)
|> filter(fn: (r) => r["_measurement"] == "pvforecast.0.plants.westseiteEigen.power")
|> filter(fn: (r) => r["_field"] == "value")
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: "mean")

Das wäre der Befehl für die Werte morgen (Graue Linie)

from(bucket: "Solar")
|> range(start: -12h, stop: 12h)
|> timeShift (duration: -24h)
|> filter(fn: (r) => r["_measurement"] == "pvforecast.0.plants.westseiteEigen.power")
|> filter(fn: (r) => r["_field"] == "value")
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: "mean")

Das wäre der Befehl für die Werte heute (Farbige Fläche)

Die nervöse Linie ist der aktuelle Ertrag der PV Anlaga

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

Spoiler

{ "__inputs": [ { "name": "DS_INFLUXDB", "label": "InfluxDB", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "panel", "id": "gauge", "name": "Gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "10.0.3" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "description": "Wasserverbrauch", "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": null, "links": [ { "asDropdown": true, "icon": "external link", "includeVars": true, "keepTime": true, "tags": [ "Hausenergie" ], "targetBlank": false, "title": "Hausenergie", "tooltip": "", "type": "dashboards", "url": "" } ], "liveNow": false, "panels": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "custom": { "align": "right", "cellOptions": { "type": "auto" }, "filterable": false, "inspect": false }, "decimals": 3, "mappings": [], "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": "" }

@marc-berg said in Grafana: täglichen Solar-Ertrag summieren:

timeSrc: "_start"

Super!! Das war die Lösung.

@dede2403 sagte in Grafana Datum stimmt nicht:

Danke kann geschlossen werden.

Das ist aber deine Aufgabe, indem du deinen ersten Post editierst und "gelöst" mit in den Betreff setzt. 🙂

Aaahrg, ich habe übersehen, dass ich ein "Transform" eingebaut hatte, dessen Graph dann die Linie immer übermalt hat. Jetzt klappts 🙂

5a595d5e-88a9-4a08-8efb-766f06b4ff4f-image.png

@astrakid nachtrag: du musst die werte regelmäßig in deine influxdb schreiben, je nachdem wie granular das haben willst. ich schreibe alle 10s einen wert in die DBen und aggregiere später. für die tagesanzeige gehe ich auf minuten-intervalle, für wochen und monats ansichten auf 6h intervalle.

@base 👍 genau das was ich auch gesucht habe Danke