-
-
Save TheRealSimon42/11120026fe0bbfe64ad82b88e050dde8 to your computer and use it in GitHub Desktop.
Grafana Stromverbrauch / Erzeugung Dashboard von usekevin aus der simon42 Community
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "annotations": { | |
| "list": [ | |
| { | |
| "builtIn": 1, | |
| "datasource": { | |
| "type": "grafana", | |
| "uid": "-- Grafana --" | |
| }, | |
| "enable": true, | |
| "hide": true, | |
| "iconColor": "rgba(0, 211, 255, 1)", | |
| "name": "Annotations & Alerts", | |
| "target": { | |
| "limit": 100, | |
| "matchAny": false, | |
| "tags": [], | |
| "type": "dashboard" | |
| }, | |
| "type": "dashboard" | |
| } | |
| ] | |
| }, | |
| "editable": true, | |
| "fiscalYearStartMonth": 0, | |
| "graphTooltip": 0, | |
| "id": 1, | |
| "links": [], | |
| "liveNow": false, | |
| "panels": [ | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 35, | |
| "panels": [], | |
| "title": "Row title", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "description": "", | |
| "gridPos": { | |
| "h": 2, | |
| "w": 24, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "id": 33, | |
| "options": { | |
| "code": { | |
| "language": "plaintext", | |
| "showLineNumbers": false, | |
| "showMiniMap": false | |
| }, | |
| "content": "<center><h6>Start der Anlage: 13.11.2022</h6></center>\r\n", | |
| "mode": "html" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "type": "text" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 2, | |
| "x": 0, | |
| "y": 3 | |
| }, | |
| "id": 6, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "none" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "zaehlerstand1", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Zählerstand", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "noValue": "0,00 €", | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "€" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 2, | |
| "y": 3 | |
| }, | |
| "id": 45, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "center", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "heutegespart", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"HeuteErzeugt\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Heute Gespart", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "decimals": 0, | |
| "mappings": [], | |
| "max": 700, | |
| "min": 1, | |
| "noValue": "0 W", | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "red", | |
| "value": null | |
| }, | |
| { | |
| "color": "orange", | |
| "value": 300 | |
| }, | |
| { | |
| "color": "green", | |
| "value": 500 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 4, | |
| "x": 4, | |
| "y": 3 | |
| }, | |
| "id": 9, | |
| "interval": "1", | |
| "options": { | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showThresholdLabels": true, | |
| "showThresholdMarkers": true, | |
| "text": { | |
| "titleSize": 10 | |
| } | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "TotalPower", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Solar Erzeugung", | |
| "type": "gauge" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "decimals": 0, | |
| "mappings": [], | |
| "max": 700, | |
| "min": 1, | |
| "noValue": "0 W", | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "orange", | |
| "value": 300 | |
| }, | |
| { | |
| "color": "red", | |
| "value": 500 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 4, | |
| "x": 8, | |
| "y": 3 | |
| }, | |
| "id": 44, | |
| "interval": "1", | |
| "options": { | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showThresholdLabels": true, | |
| "showThresholdMarkers": true, | |
| "text": { | |
| "titleSize": 10 | |
| } | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "zurueckzumnetzwatt", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Überschuss", | |
| "type": "gauge" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "decimals": 0, | |
| "mappings": [], | |
| "max": 2500, | |
| "min": 1, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "orange", | |
| "value": 1000 | |
| }, | |
| { | |
| "color": "red", | |
| "value": 2000 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 4, | |
| "x": 12, | |
| "y": 3 | |
| }, | |
| "id": 14, | |
| "interval": "1", | |
| "options": { | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showThresholdLabels": true, | |
| "showThresholdMarkers": true, | |
| "text": { | |
| "titleSize": 10 | |
| } | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": true, | |
| "measurement": "zaehlerwatt", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"zaehlerwatt\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ] | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": true, | |
| "measurement": "shellysolar", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "datasource": { | |
| "name": "Expression", | |
| "type": "__expr__", | |
| "uid": "__expr__" | |
| }, | |
| "expression": "$A + $B", | |
| "hide": false, | |
| "refId": "C", | |
| "type": "math" | |
| } | |
| ], | |
| "title": "Verbrauch", | |
| "transformations": [], | |
| "type": "gauge" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "description": "", | |
| "gridPos": { | |
| "h": 2, | |
| "w": 2, | |
| "x": 16, | |
| "y": 3 | |
| }, | |
| "id": 47, | |
| "options": { | |
| "code": { | |
| "language": "plaintext", | |
| "showLineNumbers": false, | |
| "showMiniMap": false | |
| }, | |
| "content": "<center><h6>Stromkosten</h6></center>\r\n", | |
| "mode": "html" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "type": "text" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| } | |
| }, | |
| "decimals": 2, | |
| "mappings": [] | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Bezug" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "color", | |
| "value": { | |
| "fixedColor": "red", | |
| "mode": "fixed" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Solar" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "color", | |
| "value": { | |
| "fixedColor": "green", | |
| "mode": "fixed" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 6, | |
| "x": 18, | |
| "y": 3 | |
| }, | |
| "id": 24, | |
| "options": { | |
| "displayLabels": [ | |
| "name", | |
| "percent" | |
| ], | |
| "legend": { | |
| "displayMode": "list", | |
| "placement": "bottom", | |
| "showLegend": false | |
| }, | |
| "pieType": "pie", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "tooltip": { | |
| "mode": "single", | |
| "sort": "desc" | |
| } | |
| }, | |
| "targets": [ | |
| { | |
| "alias": "Bezug", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "tagesverbrauch", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "Solar", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "shellysolarheute", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "transparent": true, | |
| "type": "piechart" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "text", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "€" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 16, | |
| "y": 5 | |
| }, | |
| "id": 25, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "center", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "tagesverbrauch", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"HeuteErzeugt\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " * 0.3667" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Heute", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "noValue": "0,00 €", | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "€" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 2, | |
| "y": 6 | |
| }, | |
| "id": 46, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "center", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "gesamtgespart", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"HeuteErzeugt\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Insg. Gespart", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "text", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "€" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 16, | |
| "y": 8 | |
| }, | |
| "id": 26, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "center", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "monatsverbrauch", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"HeuteErzeugt\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " * 0.3667 +13.15" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Monat", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "kWh" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 0, | |
| "y": 9 | |
| }, | |
| "id": 18, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "GesamtErzeugt", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Insgesamt Produziert", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "noValue": "0.00 kWh", | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "kwatth" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 2, | |
| "y": 9 | |
| }, | |
| "id": 20, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "shellysolarheute", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"HeuteErzeugt\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Heute Produziert", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "noValue": "0,00 €", | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "text", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "€" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 4, | |
| "y": 9 | |
| }, | |
| "id": 21, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "center", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "shellysolarheute", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"HeuteErzeugt\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| }, | |
| { | |
| "params": [ | |
| " * 0.3667" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Heute Erzeugt", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "text", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "€" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 6, | |
| "y": 9 | |
| }, | |
| "id": 22, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "GesamtErzeugt", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| "* 0.3667" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Gesamt Erzeugt", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "kWh" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 12, | |
| "y": 9 | |
| }, | |
| "id": 30, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "tagesverbrauch", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Verbr. Tag", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "kWh" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 14, | |
| "y": 9 | |
| }, | |
| "id": 31, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.2.4", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "monatsverbrauch", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Verbr. Monat", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": -1, | |
| "drawStyle": "line", | |
| "fillOpacity": 24, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "lineInterpolation": "smooth", | |
| "lineStyle": { | |
| "fill": "solid" | |
| }, | |
| "lineWidth": 3, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "log": 2, | |
| "type": "log" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "off" | |
| } | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Erzeugung" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "color", | |
| "value": { | |
| "fixedColor": "yellow", | |
| "mode": "fixed" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Verbrauch" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "color", | |
| "value": { | |
| "fixedColor": "green", | |
| "mode": "fixed" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 11, | |
| "w": 24, | |
| "x": 0, | |
| "y": 12 | |
| }, | |
| "id": 2, | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "displayMode": "list", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "9.1.6", | |
| "targets": [ | |
| { | |
| "alias": "Zähler", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "linear" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": true, | |
| "measurement": "zaehlerwatt", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "Erzeugung", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "linear" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": true, | |
| "measurement": "shellysolar", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "datasource": { | |
| "name": "Expression", | |
| "type": "__expr__", | |
| "uid": "__expr__" | |
| }, | |
| "expression": "$A + $B", | |
| "hide": false, | |
| "refId": "Verbrauch", | |
| "type": "math" | |
| }, | |
| { | |
| "alias": "Erzeugung", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "NI4OYAvVz" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "linear" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "poweraktuell", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "C", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Erzeugung / Verbrauch", | |
| "type": "timeseries" | |
| } | |
| ], | |
| "refresh": "5s", | |
| "schemaVersion": 37, | |
| "style": "dark", | |
| "tags": [], | |
| "templating": { | |
| "list": [] | |
| }, | |
| "time": { | |
| "from": "now-15m", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ] | |
| }, | |
| "timezone": "", | |
| "title": "Test", | |
| "uid": "3A-g90D4z", | |
| "version": 59, | |
| "weekStart": "" | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment