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 [image: 1715175374941-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 :-) [image: 1713281165392-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

@thecad jetzt verstanden ;) Hat der Akku keine App die dir was anzeigt ? Die Entnahme aus dem Akku kannst du aber perfekt bestimmen, zumindest in der Zeit, wo die Sonne untergegangen ist. Da hast du ja nur Akku Versorgung. Dann müsstest du mit Blockly einfach den Wert beim Sonnen Untergang + Aufgang tracken . Und die Differenz ist das, was du über die Nacht eingespeißt hast. Tagsüber ist es in der Tat schwierig. Ich hab kein Akku, gibt hier sicher aber welche, die da weiterhelfen können ;)

@markus-7 Bezüglich der Legende hat ja @Negalein schon alles gezeigt.Ich wollte noch anmerken, dass der Code in dieser Version komplett simpel ist. pivot, rename und drop sind nicht nötig, wird alles durch Transform data erledigt. from(bucket: "iobroker") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "iob.temp.badezimmer" or r["_measurement"] == "iob.temp.esskueche") |> filter(fn: (r) => r["_field"] == "value") |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false) sollte reichen. oder einfach from(bucket: "iobroker") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] =~ /(.*\.temp\..*) |> filter(fn: (r) => r["_field"] == "value") |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false) Wenn du alle ?.temp.? datenpunkte haben willst.

Hallo, leider wird mit meines Code kein Bardiagramm mit täglichen Werten erzeugt. Irgendwie muss das doch auch möglich sein, kann mir da jmd einen Tipp geben?

@brenner-0 Nein. Ich habe letztendlich 3 Tabellen nebeneinader gesetzt.

@homoran Hab mir eCharts gerade mal angesehen. Sieht ganz gut aus! Werde wohl darauf umstellen. So viele Charts habe ich mit Flot noch nicht gebaut, die paar sind in eCharts schnell nachgebaut. Danke für die Info!

@michael_bs sagte in Hilfe: Grafana status failed: ja alles in einer VM. Wäre es sinnvoller zu trennen? logisch sinnvoller, dafür nutzt man ja Proxmox um alles zu separieren @michael_bs sagte in Hilfe: Grafana status failed: )installieren, wie auf der Seite von grafana beschrieben: so? https://grafana.com/docs/grafana/latest/setup-grafana/installation/debian/?src=ggl-s&mdm=cpc&cnt=118483912276&camp=b-grafana-exac-emea&trm=grafana&pg=oss-graf&plcmt=hero-btn-2 @michael_bs sagte in Hilfe: Grafana status failed: grafana-enterprise warum die enterprise? mach mal apt policy grafana*

@mibr85 sagte in Grafana nur Ergebnis der berechnung anzeigen: wofür ist diese ominöse zeile überhaupt da bzw was bewirkt die? Das Ergebnis der Flux-Abfrage ist eine Tabelle, die im Default einfach "_result" heißt. Mit "yield" kann man diese Tabelle umbenennen. Bei einfachen Abfragen vollkommen sinnlos, soviel ich weiß wird dies von Grafana nicht ausgewertet. Spoiler [image: 1710151126988-8cab208b-4ff0-472a-a060-d2d7ad4669fb-grafik.png] Man kann die Funktion aber auch sinnvoll nutzen, wenn man mit einer Abfrage mehrere Ergebnisse haben will.

@woupi Ich musste den Wert des gesamtverbrauches nehmen und nicht den aktuellen

@michael-sauer Habs! [image: 1709138783639-3c7f832e-aea3-43e7-884b-9172e41f71b4-image.png] [image: 1709138809401-b5aa6847-243d-4cf5-87f0-20da1a1d42f1-image.png]

@wibear sagte in Grafana startet nicht mehr nach Anpassungen in grafana.ini: logger=settings t=2024-02-23T18:34:08.69127539+01:00 level=error msg="failed to parse "/etc/grafana/grafana.ini": key-value delimiter not found: w##################### Grafana Configuration Example #####################\n" Wie @arteck schon schrieb, in deiner grafana.ini steht offenbar Grütze. Die musst du korrigieren/Backup zurückspielen. logger=authn.service t=2024-02-23T15:18:53.338587547+01:00 level=warn msg="Failed to authenticate request" client=auth.client.session error="user token not found" Das ist in diesem Fall kein InfluxDB Token, sondern der interne Grafana-Token, der bei der Anmeldung erzeugt und in einem Cookie gespeichert wird. Du könntest versuchen, Cookies in deinem Browser zu löschen. In jedem Fall muss aber vorher die grafana.ini sauber sein.