{ "datasource": { "type": "influxdb", "uid": "000000001" }, "description": "", "fieldConfig": { "defaults": { "custom": { "lineWidth": 1, "fillOpacity": 80, "gradientMode": "none", "axisPlacement": "auto", "axisLabel": "", "axisColorMode": "text", "axisBorderShow": false, "scaleDistribution": { "type": "linear" }, "axisCenteredZero": false, "hideFrom": { "tooltip": false, "viz": false, "legend": false }, "thresholdsStyle": { "mode": "off" } }, "color": { "mode": "fixed", "fixedColor": "red" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "links": [], "min": 0, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time: D dd" } ] } ] }, "gridPos": { "h": 7, "w": 12, "x": 12, "y": 27 }, "hideTimeOverride": true, "id": 98, "interval": "1d", "links": [], "options": { "orientation": "auto", "xTickLabelRotation": -90, "xTickLabelSpacing": 0, "showValue": "always", "stacking": "none", "groupWidth": 0.7, "barWidth": 0.7, "barRadius": 0, "fullHighlight": false, "tooltip": { "mode": "single", "sort": "none" }, "legend": { "showLegend": false, "displayMode": "list", "placement": "bottom", "calcs": [] } }, "pluginVersion": "8.5.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "000000001" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "0_userdata.0.Energie.PV.Netzbezug", "orderByTime": "ASC", "policy": "default", "query": "import \"timezone\"\r\noption location = timezone.location(name: \"Europe/Berlin\")\r\n\r\nfrom(bucket: \"iobroker\")\r\n |> range(start: -1mo, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"smartmeter.0.1-0:1_8_0__255.value\" and r[\"_field\"] == \"value\")\r\n |> difference()\r\n |> aggregateWindow(every: 1d, fn: sum, timeSrc: \"_start\")", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "max" } ] ], "tags": [] }, { "alias": "Direct self-use", "datasource": { "type": "influxdb", "uid": "000000001" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "kWh", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "max" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "selfuse_energy_daily" } ] } ], "timeFrom": "1h", "title": "Tagesbezug (Monat)", "type": "barchart" }