{ "__inputs": [ { "name": "DS_INFLUXDB", "label": "InfluxDB", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" }, { "name": "DS_INFLUXDB-COLLECTD", "label": "InfluxDB-collectd", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "panel", "id": "gauge", "name": "Gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "9.2.4" }, { "type": "panel", "id": "graph", "name": "Graph (old)", "version": "" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "datasource", "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": "Stromverbrauch", "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 1, "id": null, "links": [ { "$$hashKey": "object:155", "asDropdown": true, "icon": "external link", "keepTime": true, "tags": [ "Hausenergie" ], "title": "Hausenegie", "type": "dashboards" } ], "liveNow": false, "panels": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "custom": { "align": "right", "displayMode": "auto", "filterable": false, "inspect": false, "width": 80 }, "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "blue", "value": null }, { "color": "yellow", "value": 9 }, { "color": "orange", "value": 12 }, { "color": "red", "value": 15 } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "Verbrauch" }, "properties": [ { "id": "custom.displayMode", "value": "gradient-gauge" }, { "id": "custom.width", "value": 200 } ] }, { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:D.M.Y" }, { "id": "displayName", "value": "Tag" } ] }, { "matcher": { "id": "byName", "options": "Verbrauch * 0.275" }, "properties": [ { "id": "displayName", "value": "Kosten" }, { "id": "unit", "value": "currencyEUR" } ] } ] }, "gridPos": { "h": 28, "w": 5, "x": 0, "y": 0 }, "id": 26, "options": { "footer": { "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [] }, "pluginVersion": "9.2.4", "targets": [ { "alias": "Verbrauch", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_1", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "timeFrom": "1M", "title": "Stromverlauf", "transformations": [ { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "Time" } ] } }, { "id": "calculateField", "options": { "binary": { "left": "Verbrauch", "operator": "*", "reducer": "sum", "right": "0.275" }, "mode": "binary", "reduce": { "reducer": "sum" } } } ], "transparent": true, "type": "table" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "fieldConfig": { "defaults": { "custom": { "align": "right", "displayMode": "auto", "filterable": false, "inspect": false, "width": 80 }, "decimals": 2, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "super-light-green", "value": null }, { "color": "light-green", "value": 2 }, { "color": "green", "value": 3 }, { "color": "semi-dark-green", "value": 4 }, { "color": "dark-green", "value": 5 } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "Produziert" }, "properties": [ { "id": "custom.displayMode", "value": "gradient-gauge" }, { "id": "custom.width", "value": 200 } ] }, { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time:D.M.Y" }, { "id": "displayName", "value": "Tag" } ] }, { "matcher": { "id": "byName", "options": "Produziert * 0.275" }, "properties": [ { "id": "unit", "value": "currencyEUR" }, { "id": "displayName", "value": "Ersparnis" } ] } ] }, "gridPos": { "h": 28, "w": 5, "x": 5, "y": 0 }, "id": 33, "options": { "footer": { "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [] }, "pluginVersion": "9.2.4", "targets": [ { "alias": "Produziert", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "mqtt.0.Balkonkraftwerk.HM-600.ch0.YieldTotal", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "timeFrom": "1M", "title": "Balkonkraftwerk", "transformations": [ { "id": "sortBy", "options": { "fields": {}, "sort": [ { "desc": true, "field": "Time" } ] } }, { "id": "calculateField", "options": { "binary": { "left": "Produziert", "operator": "*", "reducer": "sum", "right": "0.275" }, "mode": "binary", "reduce": { "reducer": "sum" } } } ], "transparent": true, "type": "table" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 3, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "yellow", "value": 0.35 }, { "color": "orange", "value": 0.75 }, { "color": "red", "value": 1 } ] }, "unit": "kw" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 10, "y": 0 }, "id": 12, "links": [], "maxDataPoints": 100, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "wiffi-wz.0.root.10_1_30_10.w_power_1", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "title": "aktuell", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 1, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwh" }, "overrides": [] }, "gridPos": { "h": 2, "w": 4, "x": 14, "y": 0 }, "id": 9, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.currentYear.consumed.05_currentYear", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "Jahresverbrauch", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 1, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 18, "y": 0 }, "id": 18, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.consumption.02_current_week", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "title": "Wochenwert", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 1, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 21, "y": 0 }, "id": 32, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "mqtt.0.Balkonkraftwerk.HM-600.ch0.YieldDay", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "title": "BKW aktuell", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 2, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "max": 165, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "#299c46", "value": null }, { "color": "#F2CC0C", "value": 80 }, { "color": "#d44a3a", "value": 130 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 14, "y": 2 }, "id": 15, "links": [], "maxDataPoints": 100, "options": { "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": false }, "pluginVersion": "9.2.4", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.cost.03_current_month", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "title": "Monat", "type": "gauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 2, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "#299c46", "value": null }, { "color": "rgba(237, 129, 40, 0.89)", "value": 20 }, { "color": "#d44a3a", "value": 30 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 18, "y": 2 }, "id": 16, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.cost.02_current_week", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "title": "Woche", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 1, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 21, "y": 2 }, "id": 29, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "mqtt.0.Balkonkraftwerk.HM-600.ch0.YieldTotal", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "title": "BKW Gesamt", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 2, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 2, "w": 4, "x": 10, "y": 4 }, "id": 14, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.cost.01_current_day", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "title": "Heute", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 3, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 18, "y": 4 }, "id": 10, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_1", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "title": "Zaehlerstand", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 2, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "currencyEUR" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 21, "y": 4 }, "id": 17, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.2.4", "targets": [ { "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.cost.05_current_year", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "title": "Jahr", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 100, "gradientMode": "opacity", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "line" } }, "links": [], "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "green", "value": 320 }, { "color": "orange", "value": 650 }, { "color": "red", "value": 1000 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Gesamt" }, "properties": [ { "id": "color", "value": { "fixedColor": "semi-dark-blue", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "solar" }, "properties": [ { "id": "color", "value": { "fixedColor": "#73BF69", "mode": "fixed" } }, { "id": "unit", "value": "watt" } ] } ] }, "gridPos": { "h": 9, "w": 14, "x": 10, "y": 6 }, "id": 11, "links": [], "options": { "legend": { "calcs": [ "mean", "lastNotNull", "max", "min" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.5.2", "targets": [ { "alias": "Gesamt", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "wiffi-wz.0.root.10_1_30_10.w_power_1", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ " *1000" ], "type": "math" } ] ], "tags": [] }, { "alias": "solar", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "10s" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "shelly.0.shellyplus1pm#7c87ce64d518#1.Relay0.Power", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "*-1" ], "type": "math" } ] ], "tags": [] } ], "timeFrom": "1d", "title": "aktueller Gesamtverbrauch", "transparent": true, "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "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" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "shelly.0.shellyplus1pm#7c87ce64d518#1.Relay0.Power.mean" }, "properties": [ { "id": "color", "value": { "fixedColor": "green", "mode": "fixed" } }, { "id": "custom.axisPlacement", "value": "right" }, { "id": "unit", "value": "none" } ] }, { "matcher": { "id": "byName", "options": "Energy" }, "properties": [ { "id": "unit", "value": "kwh" } ] } ] }, "gridPos": { "h": 7, "w": 8, "x": 10, "y": 15 }, "id": 31, "options": { "legend": { "calcs": [ "last", "max", "mean" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "targets": [ { "alias": "Power AC", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "mqtt.0.Balkonkraftwerk.HM-600.ch0.P_AC", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] }, { "alias": "Power DC", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "mqtt.0.Balkonkraftwerk.HM-600.ch0.P_DC", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] }, { "alias": "Energy", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB-COLLECTD}" }, "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "hide": false, "measurement": "mqtt.0.Balkonkraftwerk.HM-600.ch0.YieldDay", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ " / 1000" ], "type": "math" } ] ], "tags": [] } ], "title": "Balkonkraftwerk", "transparent": true, "type": "timeseries" }, { "aliasColors": { "Lichter": "semi-dark-blue" }, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "links": [] }, "overrides": [] }, "fill": 1, "fillGradient": 10, "gridPos": { "h": 7, "w": 6, "x": 18, "y": 15 }, "hiddenSeries": false, "id": 20, "legend": { "alignAsTable": true, "avg": false, "current": true, "max": false, "min": false, "rightSide": false, "show": true, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null as zero", "options": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.2.4", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "alias": "Lichter", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "virtualpowermeter.0.group_Licht.Virtual_Energy_Power_group_Licht", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "thresholds": [], "timeRegions": [], "title": "Licht", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:2770", "format": "watt", "label": "", "logBase": 1, "show": true }, { "$$hashKey": "object:2771", "format": "short", "logBase": 1, "show": true } ], "yaxis": { "align": false } }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "blue" }, { "color": "yellow", "value": 12 }, { "color": "orange", "value": 15 }, { "color": "red", "value": 18 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 6, "w": 7, "x": 10, "y": 22 }, "hideTimeOverride": true, "id": 22, "interval": "", "options": { "displayMode": "gradient", "minVizHeight": 10, "minVizWidth": 0, "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showUnfilled": true, "text": {} }, "pluginVersion": "9.2.4", "targets": [ { "alias": "Mo", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.currentYear.consumed.currentWeek.01_Monday", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Di", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.currentYear.consumed.currentWeek.02_Tuesday", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Mi", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.currentYear.consumed.currentWeek.03_Wednesday", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Do", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.currentYear.consumed.currentWeek.04_Thursday", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Fr", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.currentYear.consumed.currentWeek.05_Friday", "orderByTime": "ASC", "policy": "default", "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Sa", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.currentYear.consumed.currentWeek.06_Saturday", "orderByTime": "ASC", "policy": "default", "refId": "F", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "So", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "sourceanalytix.0.wiffi-wz__0__root__10_1_30_10__w_counter_1.currentYear.consumed.currentWeek.07_Sunday", "orderByTime": "ASC", "policy": "default", "refId": "G", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "timeFrom": "7d", "title": "Tagesverbrauch", "transparent": true, "type": "bargauge" }, { "aliasColors": { "virtualpowermeter.0.group_Geraete.Virtual_Energy_Power_group_Geraete.last": "semi-dark-blue", "virtualpowermeter.0.group_Geraete.Virtual_Energy_Power_group_Geraete.mean": "semi-dark-blue" }, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "links": [] }, "overrides": [] }, "fill": 1, "fillGradient": 10, "gridPos": { "h": 6, "w": 7, "x": 17, "y": 22 }, "hiddenSeries": false, "id": 19, "legend": { "alignAsTable": true, "avg": false, "current": true, "max": false, "min": false, "rightSide": false, "show": true, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null as zero", "options": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.2.4", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "virtualpowermeter.0.group_Geraete.Virtual_Energy_Power_group_Geraete", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "thresholds": [], "timeRegions": [], "title": "TV/Geräte", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "watt", "logBase": 1, "show": true }, { "format": "short", "logBase": 1, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": { "Heizung": "semi-dark-blue" }, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "decimals": 2, "fieldConfig": { "defaults": { "links": [] }, "overrides": [] }, "fill": 2, "fillGradient": 4, "gridPos": { "h": 6, "w": 24, "x": 0, "y": 28 }, "hiddenSeries": false, "id": 5, "legend": { "alignAsTable": true, "avg": true, "current": true, "max": true, "min": false, "rightSide": true, "show": true, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null as zero", "options": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.2.4", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "alias": "Heizung", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.Heizung.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Gefriertruhe", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.Gefriertruhe.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Kühlschrank", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.Kuehlschrank.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "PC-Server", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.PC-Server.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "thresholds": [], "timeRegions": [], "title": "Betriebsgeräte", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:2635", "format": "watt", "logBase": 1, "show": true }, { "$$hashKey": "object:2636", "format": "short", "logBase": 1, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": { "Brunnen": "semi-dark-blue" }, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "decimals": 2, "fieldConfig": { "defaults": { "links": [] }, "overrides": [] }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 24, "x": 0, "y": 34 }, "hiddenSeries": false, "id": 2, "legend": { "alignAsTable": true, "avg": false, "current": true, "hideEmpty": false, "hideZero": false, "max": true, "min": false, "rightSide": true, "show": true, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null as zero", "options": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.2.4", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "alias": "Waschmaschine/Trockner", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.Waschmaschine.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Geschirrspüler/Wasserkocher", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.Geschirrspueler.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Kaffeautomat", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.Kaffeeautomat.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Microwelle", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.Microwelle.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } }, { "alias": "Brunnen", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "previous" ], "type": "fill" } ], "measurement": "sonoff.0.Brunnen.ENERGY_Power", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [], "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" } } ], "thresholds": [], "timeRegions": [], "title": "Geräte", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:216", "format": "watt", "logBase": 2, "show": true }, { "$$hashKey": "object:217", "format": "watt", "logBase": 1, "show": false } ], "yaxis": { "align": false } }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-BlYlRd" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "bars", "fillOpacity": 54, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "line+area" } }, "links": [], "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent" }, { "color": "red", "value": 12 }, { "color": "orange", "value": 13 }, { "color": "red", "value": 16 } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "wiffi-wz.0.root.10_1_30_10.w_counter_1.moving_average" }, "properties": [ { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } }, { "id": "custom.drawStyle", "value": "line" }, { "id": "custom.fillOpacity", "value": 0 } ] }, { "matcher": { "id": "byName", "options": "Stromverbrauch" }, "properties": [ { "id": "color", "value": { "fixedColor": "#1f60c4", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 7, "w": 24, "x": 0, "y": 40 }, "id": 24, "interval": "10s", "links": [], "options": { "legend": { "calcs": [ "mean", "max", "min" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "pluginVersion": "8.3.3", "targets": [ { "alias": "Stromverbrauch", "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "24h" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "wiffi-wz.0.root.192_168_178_33.w_counter_1", "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"wiffi-wz.0.root.10_1_30_10.w_counter_1\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "wiffi-wz.0.root.10_1_30_10.w_counter_1", "orderByTime": "ASC", "policy": "default", "query": "SELECT moving_average(difference(last(\"value\")),30) FROM \"wiffi-wz.0.root.10_1_30_10.w_counter_1\" WHERE $timeFilter GROUP BY time(1d) fill(previous) tz('Europe/Berlin')", "rawQuery": false, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" }, { "params": [ 5 ], "type": "moving_average" } ] ], "tags": [] } ], "timeFrom": "1M", "title": "Strom", "transparent": true, "type": "timeseries" } ], "refresh": "1m", "schemaVersion": 37, "style": "dark", "tags": [ "Hausenergie" ], "templating": { "list": [] }, "time": { "from": "now-24h", "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": "browser", "title": "Strom", "uid": "Lld6uhRZk", "version": 200, "weekStart": "" }