{ "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": "", "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": 5, "links": [], "liveNow": true, "panels": [ { "datasource": { "type": "influxdb", "uid": "pKW-cAggz" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "continuous-GrYlRd" }, "decimals": 0, "mappings": [], "max": 5000, "min": 0, "thresholds": { "mode": "percentage", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 8, "w": 5, "x": 0, "y": 0 }, "id": 2, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.5.2", "targets": [ { "datasource": { "type": "influxdb", "uid": "pKW-cAggz" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Leistungsdaten", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Momentanleistung" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "title": "Aktueller Verbrauch", "type": "gauge" }, { "datasource": { "type": "influxdb", "uid": "pKW-cAggz" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Leistung", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Leistung", "mappings": [], "max": 5000, "min": -5000, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 8, "w": 19, "x": 5, "y": 0 }, "id": 4, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "pKW-cAggz" }, "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "linear" ], "type": "fill" } ], "measurement": "Leistungsdaten", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Momentanleistung" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Leistungsverlauf", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "pKW-cAggz" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "displayMode": "auto", "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD.MM" }, { "id": "custom.width", "value": 70 }, { "id": "displayName", "value": "Tag" } ] }, { "matcher": { "id": "byName", "options": "Leistungsdaten.difference" }, "properties": [ { "id": "displayName", "value": "Energie" }, { "id": "unit", "value": "kwatth" }, { "id": "custom.displayMode", "value": "gradient-gauge" }, { "id": "color", "value": { "mode": "continuous-GrYlRd" } }, { "id": "min", "value": 0 }, { "id": "max", "value": 30 } ] } ] }, "gridPos": { "h": 11, "w": 12, "x": 0, "y": 8 }, "id": 6, "options": { "footer": { "fields": "", "reducer": [ "sum" ], "show": true }, "showHeader": true }, "pluginVersion": "8.5.2", "targets": [ { "datasource": { "type": "influxdb", "uid": "pKW-cAggz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Leistungsdaten", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "WirkerngieP" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "timeFrom": "7d", "title": "Leistung Bezug pro Tag", "transformations": [ { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "Time" } ] } } ], "type": "table" }, { "datasource": { "type": "influxdb", "uid": "pKW-cAggz" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "displayMode": "auto", "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:DD.MM" }, { "id": "custom.width", "value": 70 }, { "id": "displayName", "value": "Tag" } ] }, { "matcher": { "id": "byName", "options": "Leistungsdaten.difference" }, "properties": [ { "id": "displayName", "value": "Energie" }, { "id": "unit", "value": "kwatth" }, { "id": "custom.displayMode", "value": "gradient-gauge" }, { "id": "color", "value": { "mode": "continuous-GrYlRd" } }, { "id": "min", "value": 0 }, { "id": "max", "value": 30 } ] }, { "matcher": { "id": "byName", "options": "Vergütung" }, "properties": [ { "id": "custom.width", "value": 150 }, { "id": "unit", "value": "currencyEUR" } ] } ] }, "gridPos": { "h": 11, "w": 12, "x": 12, "y": 8 }, "id": 7, "options": { "footer": { "fields": "", "reducer": [ "sum" ], "show": true }, "showHeader": true }, "pluginVersion": "8.5.2", "targets": [ { "datasource": { "type": "influxdb", "uid": "pKW-cAggz" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Leistungsdaten", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "WirkenergieN" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "timeFrom": "7d", "title": "Leistung Lieferung pro Tag", "transformations": [ { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "Time" } ] } }, { "id": "calculateField", "options": { "alias": "Vergütung", "binary": { "left": "Leistungsdaten.difference", "operator": "*", "reducer": "sum", "right": "0.30" }, "mode": "binary", "reduce": { "reducer": "sum" } } } ], "type": "table" } ], "refresh": "", "schemaVersion": 36, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "now-1y", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Smart Meter Auswertung Blog", "uid": "GW05tggRk", "version": 17, "weekStart": "monday" }