{ "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": 15, "links": [], "liveNow": false, "panels": [ { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "orange", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [ { "matcher": { "id": "byName", "options": "Total" }, "properties": [ { "id": "thresholds", "value": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] } } ] }, { "matcher": { "id": "byName", "options": "Haushalt" }, "properties": [ { "id": "thresholds", "value": { "mode": "absolute", "steps": [ { "color": "yellow", "value": null } ] } } ] }, { "matcher": { "id": "byName", "options": "Wärmepumpen" }, "properties": [ { "id": "thresholds", "value": { "mode": "absolute", "steps": [ { "color": "purple", "value": null } ] } } ] }, { "matcher": { "id": "byName", "options": "Autos" }, "properties": [ { "id": "thresholds", "value": { "mode": "absolute", "steps": [ { "color": "super-light-blue", "value": null } ] } } ] } ] }, "gridPos": { "h": 9, "w": 6, "x": 0, "y": 0 }, "id": 17, "options": { "displayMode": "basic", "maxVizHeight": 300, "minVizHeight": 10, "minVizWidth": 0, "namePlacement": "auto", "orientation": "auto", "reduceOptions": { "calcs": [], "fields": "", "values": false }, "showUnfilled": false, "sizing": "auto", "valueMode": "color" }, "pluginVersion": "10.3.3", "targets": [ { "alias": "Total", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/Total/W" } ] }, { "alias": "Haushalt", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/House/W" } ] }, { "alias": "Wärmepumpen", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/WP/W" } ] }, { "alias": "Autos", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/CP/W" } ] } ], "title": "aktuelle Energieverbräuche", "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 6, "y": 0 }, "id": 14, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "EVU consumed", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "0" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/EVU/Z1_Power_consume" } ] } ], "title": "Bezug (EVU gesamt Z1)", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 9, "y": 0 }, "id": 24, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "HH consumed", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "0" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/EVU/Z2_Power_consume" } ] } ], "title": "Bezug (Haushalt Z2)", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 12, "y": 0 }, "id": 16, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "HH consumed", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "0" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/EVU/Z2_Power_consume" } ] }, { "alias": "Grid consumed", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "0" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/EVU/Z1_Power_consume" } ] } ], "title": "Bezug (Wärmestrom Z1-Z2)", "transformations": [ { "id": "calculateField", "options": { "alias": "Z1 - Z2 consumed", "binary": { "left": "Grid consumed", "operator": "-", "reducer": "sum", "right": "HH consumed" }, "mode": "binary", "reduce": { "include": [ "HH consumed", "Grid consumed" ], "reducer": "diff" }, "replaceFields": true } } ], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "fixed" }, "custom": { "neutral": 0 }, "decimals": 1, "fieldMinMax": false, "mappings": [], "max": 25000, "min": -25000, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "unit": "watt", "unitScale": true }, "overrides": [ { "matcher": { "id": "byName", "options": "Wärmepumpen" }, "properties": [ { "id": "color", "value": { "fixedColor": "purple", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "EVU" }, "properties": [ { "id": "color", "value": { "fixedColor": "red", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "BATT" }, "properties": [ { "id": "color", "value": { "fixedColor": "orange", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "Total" }, "properties": [ { "id": "color", "value": { "fixedColor": "green", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "Haushalt" }, "properties": [ { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "PV" }, "properties": [ { "id": "color", "value": { "fixedColor": "blue", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "Autos" }, "properties": [ { "id": "color", "value": { "fixedColor": "super-light-blue", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 9, "w": 9, "x": 15, "y": 0 }, "id": 2, "options": { "minVizHeight": 75, "minVizWidth": 75, "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true, "sizing": "auto" }, "pluginVersion": "10.3.3", "targets": [ { "alias": "Total", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/Total/W" } ] }, { "alias": "Haushalt", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/House/W" } ] }, { "alias": "Wärmepumpen", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/WP/W" } ] }, { "alias": "Autos", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/CP/W" } ] }, { "alias": "BATT", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "venus/GX/Batt_Power" } ] }, { "alias": "PV", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "F", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ " * -1" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/PV/W" } ] }, { "alias": "EVU", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "G", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "venus/GX/Grid_Power" } ] } ], "title": "Site AZ - Leistung aktuell (W)", "type": "gauge" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "NaN": { "index": 0, "text": "0" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "blue", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 6, "y": 3 }, "id": 7, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "PV Energy", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/PV/W" } ] } ], "title": "PV Erzeugung", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "NaN": { "index": 0, "text": "-" } }, "type": "value" } ], "noValue": "0", "thresholds": { "mode": "absolute", "steps": [ { "color": "blue", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 9, "y": 3 }, "id": 19, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "PV gen", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/PV/W" } ] }, { "alias": "EVU", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "autogen", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " /3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/EVU/Z1_Power_feed-in" } ] }, { "alias": "BATT", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "autogen", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " /3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "venus/GX/Batt_Power_charge" } ] } ], "title": "PV Direktverbrauch", "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "lowerOrEqual", "options": { "value": 0 } }, "fieldName": "EVU" } ], "match": "all", "type": "include" } }, { "id": "calculateField", "options": { "alias": "PV consumed", "binary": { "left": "EVU", "operator": "+", "reducer": "sum", "right": "PV gen" }, "mode": "binary", "reduce": { "reducer": "sum" }, "replaceFields": false } }, { "id": "calculateField", "options": { "alias": "PV direct", "binary": { "left": "PV consumed", "operator": "-", "reducer": "sum", "right": "BATT" }, "mode": "binary", "reduce": { "reducer": "sum" }, "replaceFields": true } } ], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "blue", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 12, "y": 3 }, "id": 12, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "Grid feed-In", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "0" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "query": "SELECT cumulative_sum(integral(\"value\"))/3600 FROM \"mqtt_consumer\" WHERE (\"topic\" = 'site/AZ/Energy/Total/W') AND $timeFilter GROUP BY time($__interval) fill(0)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " /-3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/EVU/Z1_Power_feed-in" } ] } ], "title": "Netz Einspeisung", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "noValue": "---", "thresholds": { "mode": "absolute", "steps": [ { "color": "orange", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 6, "y": 6 }, "id": 13, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "BATT geladen", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "autogen", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ " / 3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "venus/GX/Batt_Power_charge" } ] } ], "title": "Batterie Ladung", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "NaN": { "index": 0, "text": "0" } }, "type": "value" } ], "noValue": "---", "thresholds": { "mode": "absolute", "steps": [ { "color": "orange", "value": null } ] }, "unit": "watth", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 9, "y": 6 }, "id": 10, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "BATT entladen", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "integral" }, { "params": [], "type": "cumulative_sum" }, { "params": [ "/ -3600" ], "type": "math" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "venus/GX/Batt_Power_discharge" } ] } ], "title": "Batterie Entladung", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "orange", "value": null } ] }, "unit": "percent", "unitScale": true }, "overrides": [] }, "gridPos": { "h": 3, "w": 3, "x": 12, "y": 6 }, "id": 18, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "auto", "wideLayout": true }, "pluginVersion": "10.3.3", "targets": [ { "alias": "BATT SoC %", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "venus/GX/Batt_Soc" } ] } ], "title": "Batterie SoC %", "transformations": [], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt", "unitScale": true }, "overrides": [ { "matcher": { "id": "byName", "options": "WPs" }, "properties": [ { "id": "color", "value": { "fixedColor": "purple", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "Grid" }, "properties": [ { "id": "color", "value": { "fixedColor": "dark-red", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "BATT" }, "properties": [ { "id": "color", "value": { "fixedColor": "orange", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "BEVs" }, "properties": [ { "id": "color", "value": { "fixedColor": "super-light-blue", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 14, "w": 24, "x": 0, "y": 9 }, "id": 23, "options": { "legend": { "calcs": [ "min", "max", "mean" ], "displayMode": "table", "placement": "right", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "targets": [ { "alias": "Total", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/Total/W" } ] }, { "alias": "House", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/House/W" } ] }, { "alias": "WPs", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/WP/W" } ] }, { "alias": "BEVs", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/CP/W" } ] }, { "alias": "BATT", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "venus/GX/Batt_Power" } ] }, { "alias": "PV", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "F", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "site/AZ/Energy/PV/W" } ] }, { "alias": "Grid", "datasource": { "type": "influxdb", "uid": "nN8olZkGk" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "hide": false, "measurement": "mqtt_consumer", "orderByTime": "ASC", "policy": "default", "refId": "G", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "topic", "operator": "=", "value": "venus/GX/Grid_Power" } ] } ], "title": "Site AZ - Power (W)", "type": "timeseries" } ], "refresh": "30s", "revision": 1, "schemaVersion": 39, "tags": [], "templating": { "list": [] }, "time": { "from": "now-15m", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Energy Consumption", "uid": "XQDkJlU4z", "version": 68, "weekStart": "" }