{ "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" } ] }, "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": 1, "links": [], "liveNow": false, "panels": [ { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "continuous-RdYlGr" }, "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "hideTimeOverride": true, "id": 22, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^Ertrag$/", "values": false }, "textMode": "value" }, "pluginVersion": "9.4.7", "targets": [ { "alias": "Einsparung", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ " *0.4521" ], "type": "math" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "eigenverbrauch_pv_anlage" } ], "tz": "CET" }, { "alias": "Einspeisung", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "kWh", "orderByTime": "ASC", "policy": "autogen", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ " *0.086" ], "type": "math" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_to_grid_energy" } ], "tz": "CET" } ], "timeFrom": "now/d", "title": "Einsparung u. Einspeisung heute", "transformations": [ { "id": "calculateField", "options": { "alias": "Ertrag", "binary": { "left": "Einsparung", "reducer": "sum", "right": "Einspeisung" }, "mode": "binary", "reduce": { "reducer": "sum" }, "replaceFields": false } } ], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-RdYlGr" }, "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" } ] }, "unit": "currencyEUR" }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD MMM Y" }, { "id": "displayName", "value": "Datum" } ] } ] }, "gridPos": { "h": 3, "w": 6, "x": 6, "y": 0 }, "hideTimeOverride": true, "id": 5, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "sum" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "alias": "Einsparung_mtl", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "DESC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "*0.4521" ], "type": "math" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "eigenverbrauch_pv_anlage" } ], "tz": "CET" }, { "alias": "Einspeistung_mtl", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "kWh", "orderByTime": "ASC", "policy": "autogen", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "*0.086" ], "type": "math" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_to_grid_energy" } ], "tz": "CET" } ], "timeFrom": "now/M", "title": "Einsparung u. Einspeisung Monat", "transformations": [ { "id": "calculateField", "options": { "alias": "Ertrag", "binary": { "left": "Einsparung_mtl", "reducer": "sum", "right": "Einspeistung_mtl" }, "mode": "binary", "reduce": { "reducer": "sum" }, "replaceFields": true } } ], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "description": "", "fieldConfig": { "defaults": { "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 5, "w": 3, "x": 12, "y": 0 }, "hideTimeOverride": true, "id": 6, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "alias": "PV-Ertrag heute", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_daily_energy" } ], "tz": "CET" } ], "timeFrom": "now/d", "title": "PV-Ertrag", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-RdYlGr" }, "custom": { "align": "center", "cellOptions": { "mode": "gradient", "type": "gauge" }, "inspect": false }, "decimals": 2, "mappings": [], "max": 40, "thresholds": { "mode": "absolute", "steps": [ { "color": "green" } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD MMM Y" }, { "id": "displayName", "value": "Datum" }, { "id": "custom.cellOptions", "value": { "type": "auto" } }, { "id": "custom.align", "value": "center" } ] }, { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "custom.width", "value": 110 } ] } ] }, "gridPos": { "h": 5, "w": 9, "x": 15, "y": 0 }, "hideTimeOverride": true, "id": 7, "options": { "footer": { "countRows": false, "enablePagination": false, "fields": "", "reducer": [ "sum" ], "show": true }, "frameIndex": 1, "showHeader": true, "sortBy": [ { "desc": true, "displayName": "Datum" } ] }, "pluginVersion": "9.4.7", "targets": [ { "alias": "PV-Ertrag", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "DESC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_daily_energy" } ], "tz": "CET" } ], "timeFrom": "now/M", "title": "PV-Ertrag Monat", "transformations": [ { "id": "joinByField", "options": {} }, { "id": "calculateField", "options": { "alias": "PV-Eigenverbrauch", "binary": { "left": "PV-Eigennutzung", "reducer": "sum", "right": "PV-Batterie-Ladung" }, "mode": "binary", "reduce": { "reducer": "sum" } } } ], "type": "table" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "kW", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "smooth", "lineStyle": { "fill": "solid" }, "lineWidth": 3, "pointSize": 3, "scaleDistribution": { "type": "linear" }, "showPoints": "always", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 9, "w": 12, "x": 0, "y": 3 }, "hideTimeOverride": true, "id": 2, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true, "width": 38 }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "alias": "PV", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "kW", "orderByTime": "ASC", "policy": "autogen", "refId": "PV-Ertrag", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_power" } ] }, { "alias": "Batt", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "kW", "orderByTime": "ASC", "policy": "autogen", "refId": "Batterieladung", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_battery_power" } ] }, { "alias": "Netz", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "kW", "orderByTime": "ASC", "policy": "autogen", "refId": "Netzeinspeisung", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_to_grid_power" } ] }, { "alias": "Verb", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "kW", "orderByTime": "ASC", "policy": "autogen", "refId": "Stromverbrauch", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_load_power" } ] } ], "timeFrom": "8h", "title": "PV-Leistung Verlauf", "transparent": true, "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "description": "", "fieldConfig": { "defaults": { "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 5, "w": 3, "x": 12, "y": 5 }, "hideTimeOverride": true, "id": 12, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_p13147" } ], "tz": "CET" } ], "timeFrom": "now/d", "title": "Netzbezug", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-GrYlRd" }, "custom": { "align": "center", "cellOptions": { "mode": "gradient", "type": "gauge" }, "inspect": false }, "decimals": 2, "mappings": [], "max": 15, "thresholds": { "mode": "absolute", "steps": [ { "color": "green" } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD MMM Y" }, { "id": "displayName", "value": "Datum" }, { "id": "custom.cellOptions", "value": { "type": "auto" } }, { "id": "custom.align", "value": "center" } ] }, { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "custom.width", "value": 110 } ] } ] }, "gridPos": { "h": 5, "w": 9, "x": 15, "y": 5 }, "hideTimeOverride": true, "id": 13, "options": { "footer": { "countRows": false, "enablePagination": false, "fields": "", "reducer": [ "sum" ], "show": true }, "frameIndex": 1, "showHeader": true, "sortBy": [ { "desc": true, "displayName": "Datum" } ] }, "pluginVersion": "9.4.7", "targets": [ { "alias": "Netzbezug", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "DESC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_p13147" } ], "tz": "CET" } ], "timeFrom": "now/M", "title": "Netzbezug Monat", "transformations": [ { "id": "joinByField", "options": {} }, { "id": "calculateField", "options": { "alias": "PV-Eigenverbrauch", "binary": { "left": "PV-Eigennutzung", "reducer": "sum", "right": "PV-Batterie-Ladung" }, "mode": "binary", "reduce": { "reducer": "sum" } } } ], "type": "table" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "description": "", "fieldConfig": { "defaults": { "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 5, "w": 3, "x": 12, "y": 10 }, "hideTimeOverride": true, "id": 16, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_total_daily_energy" } ], "tz": "CET" } ], "timeFrom": "now/d", "title": "Stromverbrauch", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-GrYlRd" }, "custom": { "align": "center", "cellOptions": { "mode": "gradient", "type": "gauge" }, "inspect": false }, "decimals": 2, "mappings": [], "max": 20, "thresholds": { "mode": "absolute", "steps": [ { "color": "green" } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD MMM Y" }, { "id": "displayName", "value": "Datum" }, { "id": "custom.cellOptions", "value": { "type": "auto" } }, { "id": "custom.align", "value": "center" } ] }, { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "custom.width", "value": 110 } ] } ] }, "gridPos": { "h": 5, "w": 9, "x": 15, "y": 10 }, "hideTimeOverride": true, "id": 17, "options": { "footer": { "countRows": false, "enablePagination": false, "fields": "", "reducer": [ "sum" ], "show": true }, "frameIndex": 1, "showHeader": true, "sortBy": [ { "desc": true, "displayName": "Datum" } ] }, "pluginVersion": "9.4.7", "targets": [ { "alias": "Stromverbrauch", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "DESC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_total_daily_energy" } ], "tz": "CET" } ], "timeFrom": "now/M", "title": "Stromverbrauch Monat", "transformations": [ { "id": "joinByField", "options": {} }, { "id": "calculateField", "options": { "alias": "PV-Eigenverbrauch", "binary": { "left": "PV-Eigennutzung", "reducer": "sum", "right": "PV-Batterie-Ladung" }, "mode": "binary", "reduce": { "reducer": "sum" } } } ], "type": "table" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-RdYlGr" }, "decimals": 2, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "percentage", "steps": [ { "color": "dark-red" }, { "color": "#EAB839", "value": 50 }, { "color": "dark-green", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 3, "w": 12, "x": 0, "y": 12 }, "hideTimeOverride": true, "id": 21, "options": { "displayMode": "lcd", "minVizHeight": 10, "minVizWidth": 0, "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showUnfilled": true, "text": { "titleSize": 15, "valueSize": 40 } }, "pluginVersion": "9.4.7", "targets": [ { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "%", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_getpsdetail_5092014_storage_inverter_data_5092014_14_1_1_p13141" } ] } ], "timeFrom": "now/d", "title": "Batterieladung aktuell", "transparent": true, "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 5, "w": 3, "x": 0, "y": 15 }, "hideTimeOverride": true, "id": 15, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "eigenverbrauch_pv_anlage" } ], "tz": "CET" } ], "timeFrom": "now/d", "title": "PV-EV", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 2, "mappings": [], "max": 20, "thresholds": { "mode": "absolute", "steps": [ { "color": "green" } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD MMM Y" }, { "id": "displayName", "value": "Datum" } ] } ] }, "gridPos": { "h": 5, "w": 3, "x": 3, "y": 15 }, "hideTimeOverride": true, "id": 23, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "sum" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "alias": "PV-Eigenverbrauch", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "DESC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "eigenverbrauch_pv_anlage" } ], "tz": "CET" } ], "timeFrom": "now/M", "title": "PV-EV Monat", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "green", "mode": "continuous-RdYlGr" }, "decimals": 2, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "percentage", "steps": [ { "color": "dark-red" }, { "color": "#EAB839", "value": 35 }, { "color": "dark-green", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 5, "w": 3, "x": 6, "y": 15 }, "hideTimeOverride": true, "id": 18, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "%", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_daily_energy_percent" } ], "tz": "CET" } ], "timeFrom": "now/d", "title": "Autarkie", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-RdYlGr" }, "decimals": 2, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "percentage", "steps": [ { "color": "dark-red" }, { "color": "#EAB839", "value": 35 }, { "color": "dark-green", "value": 85 } ] }, "unit": "percent" }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD MMM Y" }, { "id": "displayName", "value": "Datum" } ] } ] }, "gridPos": { "h": 5, "w": 3, "x": 9, "y": 15 }, "hideTimeOverride": true, "id": 19, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "alias": "Autarkiegrad", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "%", "orderByTime": "DESC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_daily_energy_percent" } ], "tz": "CET" } ], "timeFrom": "now/M", "title": "Autarkie Monat", "transformations": [ { "id": "joinByField", "options": {} }, { "id": "calculateField", "options": { "alias": "PV-Eigenverbrauch", "binary": { "left": "PV-Eigennutzung", "reducer": "sum", "right": "PV-Batterie-Ladung" }, "mode": "binary", "reduce": { "reducer": "sum" } } } ], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "description": "", "fieldConfig": { "defaults": { "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 5, "w": 3, "x": 12, "y": 15 }, "hideTimeOverride": true, "id": 24, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.4.7", "targets": [ { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_to_grid_energy" } ], "tz": "CET" } ], "timeFrom": "now/d", "title": "Netzeinspeisung", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "continuous-GrYlRd" }, "custom": { "align": "center", "cellOptions": { "mode": "gradient", "type": "gauge" }, "inspect": false }, "decimals": 2, "mappings": [], "max": 30, "thresholds": { "mode": "absolute", "steps": [ { "color": "green" } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD MMM Y" }, { "id": "displayName", "value": "Datum" }, { "id": "custom.cellOptions", "value": { "type": "auto" } }, { "id": "custom.align", "value": "center" } ] }, { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "custom.width", "value": 110 } ] } ] }, "gridPos": { "h": 5, "w": 9, "x": 15, "y": 15 }, "hideTimeOverride": true, "id": 25, "options": { "footer": { "countRows": false, "enablePagination": false, "fields": "", "reducer": [ "sum" ], "show": true }, "frameIndex": 1, "showHeader": true, "sortBy": [ { "desc": true, "displayName": "Datum" } ] }, "pluginVersion": "9.4.7", "targets": [ { "alias": "Netzeinspeisung", "datasource": { "type": "influxdb", "uid": "JzzkvXAVz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "kWh", "orderByTime": "DESC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "entity_id", "operator": "=", "value": "gosungrow_virtual_5092014_14_1_1_pv_to_grid_energy" } ], "tz": "CET" } ], "timeFrom": "now/M", "title": "Netzeinspeisung Monat", "transformations": [ { "id": "joinByField", "options": {} }, { "id": "calculateField", "options": { "alias": "PV-Eigenverbrauch", "binary": { "left": "PV-Eigennutzung", "reducer": "sum", "right": "PV-Batterie-Ladung" }, "mode": "binary", "reduce": { "reducer": "sum" } } } ], "type": "table" } ], "refresh": "10s", "revision": 1, "schemaVersion": 38, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "now/d", "to": "now" }, "timepicker": {}, "timezone": "browser", "title": "PV-Anlage", "uid": "U5qjKuAVz", "version": 284, "weekStart": "monday" }