{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"description": "Grafana V7 Test",
"editable": true,
"gnetId": null,
"graphTooltip": 0,
"id": 5,
"links": [],
"panels": [
{
"cacheTimeout": null,
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"custom": {
"align": null
},
"decimals": 3,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": -6000
},
{
"color": "dark-green",
"value": 0
}
]
},
"unit": "watt"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Einspeisung"
},
"properties": [
{
"id": "min",
"value": -6000
},
{
"id": "max",
"value": 6000
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "dark-red",
"value": null
},
{
"color": "dark-green",
"value": 0
},
{
"color": "dark-green",
"value": 6000
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "PV Erzeugung"
},
"properties": [
{
"id": "max",
"value": 6000
},
{
"id": "min",
"value": 0
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "dark-green",
"value": null
},
{
"color": "dark-green",
"value": 80
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Batterieladung"
},
"properties": [
{
"id": "min",
"value": -6000
},
{
"id": "max",
"value": 6000
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "dark-red",
"value": null
},
{
"color": "dark-green",
"value": 0
},
{
"color": "dark-green",
"value": 6000
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Hausverbrauch"
},
"properties": [
{
"id": "max",
"value": 6000
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "dark-green",
"value": null
},
{
"color": "dark-green",
"value": 80
}
]
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 7,
"x": 0,
"y": 0
},
"id": 2,
"interval": "1m",
"links": [],
"maxDataPoints": 2000,
"options": {
"displayMode": "gradient",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"values": false
},
"showUnfilled": true
},
"pluginVersion": "7.0.0",
"repeat": null,
"targets": [
{
"alias": "Einspeisung",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"Gesamtleistung (powermeter) W\") *-1 FROM \"Solar\" WHERE $timeFilter",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Gesamtleistung (powermeter) W"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "PV Erzeugung",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"Leistung Strang 1 W\") FROM \"Solar\" WHERE $timeFilter",
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Leistung Strang 1 W"
],
"type": "field"
}
]
],
"tags": []
},
{
"alias": "Batterieladung",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"Aktuelle Batterieladung +- W\") *-1 FROM \"Solar\" WHERE $timeFilter",
"rawQuery": true,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Aktuelle Batterieladung +- W"
],
"type": "field"
},
{
"params": [
"*-1"
],
"type": "math"
}
]
],
"tags": []
},
{
"alias": "Hausverbrauch",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"Hausverbrauch aus Netz W\") + last(\"Hausverbrauch aus Batterie W\")+ last(\"Hausverbrauch aus PV W\") FROM \"Solar\" ",
"rawQuery": true,
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Aktuelle Messwerte",
"transformations": [],
"transparent": true,
"type": "bargauge"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"#8AB8FF",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": null,
"decimals": 2,
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 3,
"x": 7,
"y": 0
},
"id": 16,
"interval": "1m",
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1828",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1829",
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 10000,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "80%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Inverter Generation Power (current)\") - (sum(\"Hausverbrauch aus PV W\")+ sum(\"Hausverbrauch aus Netz W\")+sum(\"Hausverbrauch aus Batterie W\"))) /1000 /60 * 0.0981 FROM \"Solar\" WHERE $timeFilter and \"Inverter Generation Power (current)\"- (\"Hausverbrauch aus PV W\"+\"Hausverbrauch aus Netz W\" +\"Hausverbrauch aus Batterie W\") >0 GROUP BY time(1d) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Vergütung",
"transparent": true,
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"$$hashKey": "object:1831",
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "total"
},
{
"activePatternIndex": 0,
"datasource": null,
"defaultPattern": {
"bgColors": "green|orange|red",
"bgColors_overrides": "0->green|2->red|1->yellow",
"clickable_cells_link": "",
"col_name": "Wert",
"decimals": 2,
"defaultBGColor": "",
"defaultTextColor": "",
"delimiter": ".",
"displayTemplate": "_value_",
"enable_bgColor": false,
"enable_bgColor_overrides": false,
"enable_clickable_cells": false,
"enable_textColor": false,
"enable_textColor_overrides": false,
"enable_time_based_thresholds": false,
"enable_transform": false,
"enable_transform_overrides": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "watth",
"name": "Default Pattern",
"null_color": "darkred",
"null_textcolor": "black",
"null_value": "No data",
"pattern": "*",
"row_col_wrapper": "_",
"row_name": "Zähler",
"textColors": "red|orange|green",
"textColors_overrides": "0->red|2->green|1->yellow",
"thresholds": "70,90",
"time_based_thresholds": [],
"tooltipTemplate": "Series : _series_
Row Name : _row_name_
Col Name : _col_name_
Value : _value_",
"transform_values": "_value_|_value_|_value_",
"transform_values_overrides": "0->down|1->up",
"valueName": "current"
},
"default_title_for_rows": "Metric",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 6,
"x": 10,
"y": 0
},
"hide_first_column": false,
"hide_headers": true,
"id": 28,
"patterns": [],
"repeat": null,
"row_col_wrapper": "_",
"sorting_props": {
"col_index": -1,
"direction": "desc"
},
"targets": [
{
"alias": "Ertrag Tag",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Tagesertrag Wh"
],
"type": "field"
}
]
],
"tags": []
},
{
"alias": "Ertrag Monat",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Monatsertrag Wh"
],
"type": "field"
}
]
],
"tags": []
},
{
"alias": "Ertrag Jahr",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Jahresertrag Wh"
],
"type": "field"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Zähler",
"transparent": true,
"type": "yesoreyeram-boomtable-panel"
},
{
"aliasColors": {
"Hausverbrauch Netz": "#C4162A"
},
"breakPoint": "50%",
"cacheTimeout": null,
"combine": {
"label": "Others",
"threshold": 0
},
"datasource": null,
"decimals": null,
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fontSize": "80%",
"format": "watth",
"gridPos": {
"h": 6,
"w": 8,
"x": 16,
"y": 0
},
"id": 4,
"interval": "1m",
"legend": {
"percentage": true,
"percentageDecimals": 1,
"show": true,
"sideWidth": null,
"values": true
},
"legendType": "Right side",
"links": [],
"maxDataPoints": 1000,
"nullPointMode": "connected",
"pieType": "pie",
"strokeWidth": 1,
"targets": [
{
"alias": "Hausverbrauch Netz",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Hausverbrauch aus Netz W\")) /60 FROM \"Solar\" WHERE $timeFilter",
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"a1+a2+a3"
],
"type": "field"
}
],
[
{
"params": [
"Hausverbrauch aus Batterie W"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
"a1"
],
"type": "alias"
}
],
[
{
"params": [
"Hausverbrauch aus Netz W"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
"a2"
],
"type": "alias"
}
],
[
{
"params": [
"Hausverbrauch aus PV W"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
"a3"
],
"type": "alias"
}
]
],
"tags": []
},
{
"alias": "Hausverbrauch PV",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Hausverbrauch aus PV W\")) /60 FROM \"Solar\" WHERE $timeFilter",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Hausverbrauch Batterie",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Hausverbrauch aus Batterie W\")) /60 FROM \"Solar\" WHERE $timeFilter",
"rawQuery": true,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Hausverbrauch",
"transparent": true,
"type": "grafana-piechart-panel",
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"#8AB8FF",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": null,
"decimals": 2,
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 7,
"y": 2
},
"id": 18,
"interval": "1m",
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 10000,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "80%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Hausverbrauch aus Batterie W\") + sum(\"Hausverbrauch aus PV W\")) /60 /1000 *0.26FROM \"Solar\" WHERE $timeFilter GROUP BY time(1d) fill(null)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Ersparnis",
"transparent": true,
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "total"
},
{
"aliasColors": {
"Batterie entladen": "dark-blue",
"Batterie laden": "dark-green",
"Einspeisung": "light-yellow",
"Hausverbrauch": "dark-red",
"PV": "dark-yellow",
"Solar.last_last_last_last": "super-light-red",
"Sun altitude": "dark-purple",
"cloudCover": "super-light-purple"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "-- Mixed --",
"decimals": 1,
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 16,
"x": 0,
"y": 5
},
"hiddenSeries": false,
"id": 24,
"interval": "1min",
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": false,
"rightSide": true,
"show": true,
"sort": null,
"sortDesc": null,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "Batterie laden",
"fill": 0,
"zindex": 2
},
{
"alias": "Batterie entladen",
"fill": 0,
"zindex": 2
},
{
"alias": "Hausverbrauch",
"fill": 0,
"zindex": 3
},
{
"alias": "PV",
"fill": 8,
"zindex": -2
},
{
"alias": "Sun altitude",
"dashLength": 2,
"dashes": true,
"linewidth": 2,
"nullPointMode": "null as zero",
"spaceLength": 3,
"yaxis": 2
},
{
"alias": "Einspeisung",
"fill": 5,
"zindex": -1
},
{
"alias": "Batterieladung",
"yaxis": 2
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "PV",
"datasource": "solar",
"groupBy": [
{
"params": [
"1m"
],
"type": "time"
}
],
"hide": false,
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT moving_average((last(\"Leistung Strang 1 W\")),5) FROM \"Solar\" WHERE $timeFilter GROUP BY time(1m)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Leistung Strang 1 W"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
10
],
"type": "moving_average"
}
]
],
"tags": []
},
{
"alias": "Batterie laden",
"datasource": "solar",
"groupBy": [],
"hide": false,
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT moving_average(last(\"Aktuelle Batterieladung +- W\"),5) *-1 FROM \"Solar\" WHERE $timeFilter GROUP BY time(1m)",
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Aktuelle Batterieladung +- W"
],
"type": "field"
},
{
"params": [
"5"
],
"type": "moving_average"
},
{
"params": [
"*-1"
],
"type": "math"
}
]
],
"tags": []
},
{
"alias": "Batterie entladen",
"datasource": "solar",
"groupBy": [],
"hide": false,
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT moving_average(last(\"Aktuelle Batterieladung +- W\"),5) FROM \"Solar\" WHERE $timeFilter GROUP BY time(1m)",
"rawQuery": true,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Aktuelle Batterieladung +- W"
],
"type": "field"
},
{
"params": [
"5"
],
"type": "moving_average"
}
]
],
"tags": []
},
{
"alias": "Hausverbrauch",
"datasource": "solar",
"groupBy": [],
"hide": false,
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT moving_average(test,5) from (SELECT last(\"Hausverbrauch aus Batterie W\")+last(\"Hausverbrauch aus Netz W\")+last(\"Hausverbrauch aus PV W\") as test FROM \"Solar\" WHERE $timeFilter GROUP BY time(1m))",
"rawQuery": true,
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Hausverbrauch aus Batterie W"
],
"type": "field"
},
{
"params": [
"5"
],
"type": "moving_average"
}
],
[
{
"params": [
"Hausverbrauch aus Netz W"
],
"type": "field"
},
{
"params": [
"5"
],
"type": "moving_average"
}
],
[
{
"params": [
"Hausverbrauch aus PV W"
],
"type": "field"
},
{
"params": [
"5"
],
"type": "moving_average"
}
]
],
"tags": []
},
{
"alias": "Einspeisung",
"datasource": "solar",
"groupBy": [
{
"params": [
"10m"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "select moving_average(test,5) from (SELECT (last(\"Inverter Generation Power (current)\")-last(\"Hausverbrauch aus Batterie W\")-last(\"Hausverbrauch aus Netz W\")-last(\"Hausverbrauch aus PV W\")) as test FROM \"Solar\" WHERE $timeFilter GROUP BY time(1m) fill(null))",
"rawQuery": true,
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Inverter Generation Power (current)"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
],
[
{
"params": [
"Hausverbrauch aus Batterie W"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
],
[
{
"params": [
"Hausverbrauch aus Netz W"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
],
[
{
"params": [
"Hausverbrauch aus PV W"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"datasource": "Sun and Moon",
"refId": "G",
"target": "sun_altitude"
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Übersicht",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"decimals": null,
"format": "watt",
"label": "",
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"format": "none",
"label": "",
"logBase": 1,
"max": null,
"min": "0",
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": 5
}
},
{
"aliasColors": {
"Hausverbrauch Netz": "#C4162A",
"Hausverbrauch PV": "rgb(225, 9, 9)"
},
"breakPoint": "50%",
"cacheTimeout": null,
"combine": {
"label": "Others",
"threshold": 0
},
"datasource": null,
"decimals": null,
"description": "",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fontSize": "80%",
"format": "watth",
"gridPos": {
"h": 6,
"w": 8,
"x": 16,
"y": 6
},
"id": 26,
"interval": "1m",
"legend": {
"percentage": true,
"percentageDecimals": 1,
"show": true,
"sideWidth": null,
"values": true
},
"legendType": "Right side",
"links": [],
"maxDataPoints": 1000,
"nullPointMode": "connected",
"pieType": "pie",
"strokeWidth": 1,
"targets": [
{
"alias": "Einspeisung",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Inverter Generation Power (current)\") - (sum(\"Hausverbrauch aus PV W\")+ sum(\"Hausverbrauch aus Netz W\")+sum(\"Hausverbrauch aus Batterie W\"))) /60 FROM \"Solar\" WHERE $timeFilter and \"Inverter Generation Power (current)\"- (\"Hausverbrauch aus PV W\"+\"Hausverbrauch aus Netz W\" +\"Hausverbrauch aus Batterie W\") >0 ",
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"a1+a2+a3"
],
"type": "field"
}
],
[
{
"params": [
"Hausverbrauch aus Batterie W"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
"a1"
],
"type": "alias"
}
],
[
{
"params": [
"Hausverbrauch aus Netz W"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
"a2"
],
"type": "alias"
}
],
[
{
"params": [
"Hausverbrauch aus PV W"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
"a3"
],
"type": "alias"
}
]
],
"tags": []
},
{
"alias": "Hausverbrauch PV",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Hausverbrauch aus PV W\")) /60 FROM \"Solar\" WHERE $timeFilter",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Batterie",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Hausverbrauch aus Batterie W\")) /60 FROM \"Solar\" WHERE $timeFilter",
"rawQuery": true,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Aufteilung PV",
"transparent": true,
"type": "grafana-piechart-panel",
"valueName": "current"
},
{
"aliasColors": {
"Eigenverbrauch": "dark-red",
"Einspeisung": "dark-yellow",
"Ertrag": "semi-dark-blue"
},
"bars": true,
"dashLength": 10,
"dashes": false,
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 16,
"x": 0,
"y": 12
},
"hiddenSeries": false,
"hideTimeOverride": false,
"id": 30,
"interval": "1m",
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": false,
"rightSide": true,
"show": true,
"sideWidth": null,
"total": true,
"values": true
},
"lines": false,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pluginVersion": "7.0.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"repeat": null,
"seriesOverrides": [
{
"$$hashKey": "object:611",
"alias": "Eigenverbrauch",
"stack": "B"
},
{
"$$hashKey": "object:704",
"alias": "Einspeisung",
"stack": "B"
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Ertrag",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT max(\"Tagesertrag Wh\") FROM \"Solar\" WHERE $timeFilter GROUP BY time(1d)",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Eigenverbrauch",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Hausverbrauch aus PV W\")+ sum(\"Hausverbrauch aus Batterie W\")) /60 FROM \"Solar\" WHERE $timeFilter GROUP BY time(1d)",
"rawQuery": true,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Einspeisung",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (sum(\"Inverter Generation Power (current)\") - (sum(\"Hausverbrauch aus PV W\")+ sum(\"Hausverbrauch aus Netz W\")+sum(\"Hausverbrauch aus Batterie W\"))) /60 FROM \"Solar\" WHERE $timeFilter and \"Inverter Generation Power (current)\"- (\"Hausverbrauch aus PV W\"+\"Hausverbrauch aus Netz W\" +\"Hausverbrauch aus Batterie W\") >0 GROUP BY time(1d) fill(null)",
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": "1M",
"timeRegions": [],
"timeShift": null,
"title": "Übersicht Ertrag ",
"tooltip": {
"shared": true,
"sort": 1,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:805",
"format": "watth",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"$$hashKey": "object:806",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"activePatternIndex": 0,
"datasource": null,
"defaultPattern": {
"bgColors": "green|orange|red",
"bgColors_overrides": "0->green|2->red|1->yellow",
"clickable_cells_link": "",
"col_name": "Value",
"decimals": 2,
"defaultBGColor": "",
"defaultTextColor": "",
"delimiter": ".",
"displayTemplate": "_value_",
"enable_bgColor": false,
"enable_bgColor_overrides": false,
"enable_clickable_cells": false,
"enable_textColor": false,
"enable_textColor_overrides": false,
"enable_time_based_thresholds": false,
"enable_transform": false,
"enable_transform_overrides": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Default Pattern",
"null_color": "darkred",
"null_textcolor": "black",
"null_value": "No data",
"pattern": "*",
"row_col_wrapper": "_",
"row_name": "_series_",
"textColors": "red|orange|green",
"textColors_overrides": "0->red|2->green|1->yellow",
"thresholds": "70,90",
"time_based_thresholds": [],
"tooltipTemplate": "Series : _series_
Row Name : _row_name_
Col Name : _col_name_
Value : _value_",
"transform_values": "_value_|_value_|_value_",
"transform_values_overrides": "0->down|1->up",
"valueName": "avg"
},
"default_title_for_rows": "Metric",
"description": "",
"fieldConfig": {
"defaults": {
"custom": {
"align": "center"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Zyklen Batterie"
},
"properties": [
{
"id": "unit",
"value": "Zyklen"
}
]
}
]
},
"gridPos": {
"h": 9,
"w": 6,
"x": 17,
"y": 12
},
"id": 32,
"patterns": [],
"pluginVersion": "7.0.0",
"repeat": null,
"row_col_wrapper": "_",
"sorting_props": {
"col_index": -1,
"direction": "desc"
},
"targets": [
{
"alias": "Zyklen Batterie",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Anzahl Batteriezyklen"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Aktuelle Batterieladung",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Aktuelle Batterieladung +- W"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Temp Batterie",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Batterie temperatur C"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Batteriespannung",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Batteriespannung V"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Batteriestand",
"groupBy": [],
"measurement": "Solar",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Battery current SOC"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Batterie",
"transformations": [],
"transparent": true,
"type": "yesoreyeram-boomtable-panel"
}
],
"refresh": false,
"schemaVersion": 25,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now-6h",
"to": "now"
},
"timepicker": {
"refresh_intervals": [
"30m",
"1h",
"2h",
"1d",
"1M"
]
},
"timezone": "",
"title": "Kostal V7.0",
"uid": "LuIqA9Rgk",
"version": 29
}