{ "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "editable": true, "gnetId": null, "graphTooltip": 0, "id": 1, "links": [], "panels": [ { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": null, "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 8, "w": 12, "x": 0, "y": 0 }, "hiddenSeries": false, "id": 10, "legend": { "avg": false, "current": false, "hideEmpty": false, "hideZero": true, "max": false, "min": false, "show": true, "total": false, "values": false }, "lines": true, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": true, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "SMAEM", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "pdirectusage" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "Direktverbrauch" ], "type": "alias" } ], [ { "params": [ "pconsume" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "Netzbezug" ], "type": "alias" } ], [ { "params": [ "psupply" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "Überschuss" ], "type": "alias" } ] ], "tags": [ { "key": "serial", "operator": "=", "value": "1900204523" } ] } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "Eigenverbrauch, Überschuss, Netzbezug", "tooltip": { "shared": true, "sort": 0, "value_type": "cumulative" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "watt", "label": "Watt", "logBase": 1, "max": null, "min": null, "show": true }, { "decimals": null, "format": "short", "label": "", "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": null, "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fill": 2, "fillGradient": 0, "gridPos": { "h": 8, "w": 12, "x": 0, "y": 8 }, "hiddenSeries": false, "id": 8, "legend": { "avg": false, "current": false, "max": false, "min": false, "show": true, "total": false, "values": false }, "lines": true, "linewidth": 2, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "SMAEM", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "pdirectusage" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "Direktverbrauch" ], "type": "alias" } ], [ { "params": [ "pvpower" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "PV" ], "type": "alias" } ] ], "tags": [ { "key": "serial", "operator": "=", "value": "1900204523" } ] } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "PV Eigenverbrauch", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "watt", "label": "Watt", "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": null, "fieldConfig": { "defaults": { "custom": { "align": null }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "fill": 1, "fillGradient": 5, "gridPos": { "h": 8, "w": 12, "x": 0, "y": 16 }, "hiddenSeries": false, "id": 4, "legend": { "avg": false, "current": false, "max": false, "min": false, "show": true, "total": false, "values": false }, "lines": true, "linewidth": 2, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pluginVersion": "7.0.0", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "SMAEM", "orderByTime": "ASC", "policy": "autogen", "query": "SELECT mean(\"p1consume\") AS \"P1consume\", mean(\"p2consume\") AS \"P2consume\", mean(\"p3consume\") AS \"P3consume\", mean(\"p1supply\") AS \"P1suply\" FROM \"autogen\".\"SMAEM\" WHERE (\"serial\" = '1900204523') AND $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "p1consume" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "P1consume" ], "type": "alias" } ], [ { "params": [ "p2consume" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "P2consume" ], "type": "alias" } ], [ { "params": [ "p3consume" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "P3consume" ], "type": "alias" } ], [ { "params": [ "p1supply" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "P1suply" ], "type": "alias" } ], [ { "params": [ "p2supply" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "P2suply" ], "type": "alias" } ], [ { "params": [ "p3supply" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "P3suply" ], "type": "alias" } ] ], "tags": [ { "key": "serial", "operator": "=", "value": "1900204523" } ] } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "L1, L2, L3", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transformations": [ { "id": "calculateField", "options": { "alias": "L1", "binary": { "left": "SMAEM.P1consume", "operator": "-", "reducer": "sum", "right": "SMAEM.P1suply" }, "mode": "binary", "reduce": { "reducer": "sum" } } }, { "id": "calculateField", "options": { "alias": "L2", "binary": { "left": "SMAEM.P2consume", "operator": "-", "reducer": "sum", "right": "SMAEM.P2suply" }, "mode": "binary", "reduce": { "reducer": "sum" } } }, { "id": "calculateField", "options": { "alias": "L3", "binary": { "left": "SMAEM.P3consume", "operator": "-", "reducer": "sum", "right": "SMAEM.P3suply" }, "mode": "binary", "reduce": { "reducer": "sum" } } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "Time", "L1", "L2", "L3" ] } } } ], "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "watt", "label": "Watt", "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": null, "fieldConfig": { "defaults": { "custom": {}, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "fill": 1, "fillGradient": 5, "gridPos": { "h": 8, "w": 12, "x": 0, "y": 24 }, "hiddenSeries": false, "id": 6, "legend": { "avg": false, "current": false, "max": false, "min": false, "show": true, "total": false, "values": false }, "lines": true, "linewidth": 2, "nullPointMode": "connected", "options": { "dataLinks": [] }, "percentage": false, "pluginVersion": "7.0.0", "pointradius": 1, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "SMAEM", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "pconsume" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "consume" ], "type": "alias" } ], [ { "params": [ "psupply" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "supply" ], "type": "alias" } ], [ { "params": [ "pusage" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "usage" ], "type": "alias" } ], [ { "params": [ "pvpower" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "pvpower" ], "type": "alias" } ] ], "tags": [ { "key": "serial", "operator": "=", "value": "1900204523" } ] } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "SMA EM measurement 10s", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "watt", "label": "Watt", "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": { "SMAEM.Verbrauch": "#890f02" }, "bars": false, "dashLength": 10, "dashes": false, "datasource": "InfluxDB", "fieldConfig": { "defaults": { "custom": {}, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "fill": 1, "fillGradient": 5, "gridPos": { "h": 9, "w": 12, "x": 0, "y": 32 }, "hiddenSeries": false, "id": 2, "legend": { "avg": false, "current": false, "max": false, "min": false, "show": true, "total": false, "values": false }, "lines": true, "linewidth": 2, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pluginVersion": "7.0.0", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "1m" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "SMAEM", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "pconsume" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "consume" ], "type": "alias" } ], [ { "params": [ "psupply" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "supply" ], "type": "alias" } ], [ { "params": [ "pusage" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "usage" ], "type": "alias" } ], [ { "params": [ "pvpower" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "PV" ], "type": "alias" } ] ], "tags": [ { "key": "serial", "operator": "=", "value": "1900204523" } ] } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "SMA EM measurement 1min", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "watt", "label": "Watt", "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": "", "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } } ], "refresh": "5s", "schemaVersion": 25, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "now-1h", "to": "now" }, "timepicker": { "refresh_intervals": [ "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "timezone": "", "title": "SMA EM/HM", "uid": "L1e-KEymz", "version": 10 }