{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"editable": true,
"gnetId": null,
"graphTooltip": 0,
"id": 55,
"links": [],
"panels": [
{
"columns": [],
"datasource": "solaranzeige1",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fontSize": "100%",
"gridPos": {
"h": 4,
"w": 13,
"x": 0,
"y": 0
},
"id": 4,
"links": [],
"pageSize": 2,
"scroll": false,
"showHeader": true,
"sort": {
"col": null,
"desc": false
},
"styles": [
{
"$$hashKey": "object:5715",
"alias": "",
"align": "auto",
"colorMode": "cell",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": false,
"mappingType": 1,
"pattern": "Spannung",
"preserveFormat": false,
"sanitize": true,
"type": "number",
"unit": "volt",
"valueMaps": []
},
{
"$$hashKey": "object:5716",
"alias": "",
"align": "auto",
"colorMode": "row",
"colors": [
"#e0752d",
"#f2c96d",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 1,
"mappingType": 1,
"pattern": "Frequenz",
"thresholds": [],
"type": "number",
"unit": "hertz"
},
{
"$$hashKey": "object:5717",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Time",
"thresholds": [],
"type": "hidden",
"unit": "short"
},
{
"$$hashKey": "object:5718",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 0,
"mappingType": 1,
"pattern": "Last",
"thresholds": [],
"type": "number",
"unit": "percent"
},
{
"$$hashKey": "object:5719",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Leistung",
"thresholds": [],
"type": "number",
"unit": "watt"
},
{
"$$hashKey": "object:4773",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 0,
"mappingType": 1,
"pattern": "Temp.",
"thresholds": [],
"type": "number",
"unit": "celsius"
},
{
"$$hashKey": "object:497",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "PV-Volt",
"thresholds": [],
"type": "number",
"unit": "short"
}
],
"targets": [
{
"alias": "Spannung",
"groupBy": [],
"hide": false,
"measurement": "AC",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"Spannung\") , 'Netzspannung' FROM \"Netz\" WHERE $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Spannung"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Frequenz",
"groupBy": [],
"measurement": "Netz",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Frequenz"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Leistung",
"groupBy": [],
"measurement": "AC",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Scheinleistung"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Last",
"groupBy": [],
"measurement": "AC",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Ausgangslast"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Temp.",
"groupBy": [],
"measurement": "Service",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Temperatur"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "PV-Volt",
"groupBy": [],
"measurement": "PV",
"orderByTime": "ASC",
"policy": "default",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Spannung"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"title": "230 Volt Wechselrichter 1",
"transform": "timeseries_to_columns",
"type": "table-old"
},
{
"datasource": "solaranzeige3",
"description": "",
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 13,
"y": 0
},
"id": 33,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
}
},
"pluginVersion": "7.0.3",
"targets": [
{
"groupBy": [],
"measurement": "Service",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"SOC\") FROM \"Service\" WHERE $timeFilter",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"SOC"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "SOC",
"type": "stat"
},
{
"datasource": "solaranzeige3",
"description": "",
"fieldConfig": {
"defaults": {
"custom": {},
"decimals": 2,
"mappings": [],
"max": 100,
"min": -100,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "dark-red",
"value": -150
},
{
"color": "dark-red",
"value": -100
},
{
"color": "dark-red",
"value": -50
},
{
"color": "dark-green",
"value": 0
},
{
"color": "dark-green",
"value": 50
},
{
"color": "dark-green",
"value": 100
}
]
},
"unit": "amp"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 3,
"x": 15,
"y": 0
},
"id": 26,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"limit": 1,
"values": true
},
"showThresholdLabels": true,
"showThresholdMarkers": true
},
"pluginVersion": "7.0.3",
"targets": [
{
"groupBy": [],
"measurement": "Service",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"Strom_Gesamt\") FROM \"Gesamtstrom\" WHERE $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Be_Entladung"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Batterie Lade/Endlade",
"type": "gauge"
},
{
"columns": [],
"datasource": "solaranzeige2",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fontSize": "110%",
"gridPos": {
"h": 4,
"w": 13,
"x": 0,
"y": 4
},
"id": 31,
"links": [],
"pageSize": 2,
"scroll": false,
"showHeader": true,
"sort": {
"col": null,
"desc": false
},
"styles": [
{
"$$hashKey": "object:5715",
"alias": "",
"align": "auto",
"colorMode": "cell",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": false,
"mappingType": 1,
"pattern": "Spannung",
"preserveFormat": false,
"sanitize": true,
"type": "number",
"unit": "volt",
"valueMaps": []
},
{
"$$hashKey": "object:5716",
"alias": "",
"align": "auto",
"colorMode": "row",
"colors": [
"#e0752d",
"#f2c96d",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 1,
"mappingType": 1,
"pattern": "Frequenz",
"thresholds": [],
"type": "number",
"unit": "hertz"
},
{
"$$hashKey": "object:5717",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Time",
"thresholds": [],
"type": "hidden",
"unit": "short"
},
{
"$$hashKey": "object:5718",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 0,
"mappingType": 1,
"pattern": "Last",
"thresholds": [],
"type": "number",
"unit": "percent"
},
{
"$$hashKey": "object:5719",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Leistung",
"thresholds": [],
"type": "number",
"unit": "watt"
},
{
"$$hashKey": "object:4773",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 0,
"mappingType": 1,
"pattern": "Temp.",
"thresholds": [],
"type": "number",
"unit": "celsius"
}
],
"targets": [
{
"alias": "Spannung",
"groupBy": [],
"hide": false,
"measurement": "AC",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"Spannung\") , 'Netzspannung' FROM \"Netz\" WHERE $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Spannung"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Frequenz",
"groupBy": [],
"measurement": "Netz",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Frequenz"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Leistung",
"groupBy": [],
"measurement": "AC",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Scheinleistung"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Last",
"groupBy": [],
"measurement": "AC",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Ausgangslast"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Temp.",
"groupBy": [],
"measurement": "Service",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Temperatur"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"title": "230 Volt Wechselrichter 2",
"transform": "timeseries_to_columns",
"type": "table-old"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": false,
"colorValue": true,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#AD0317"
],
"datasource": "solaranzeige1",
"decimals": null,
"description": "",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "celsius",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 2,
"x": 13,
"y": 4
},
"id": 16,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:500",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:501",
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "50%",
"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
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "Service",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"Temperatur"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": "35,45,50",
"title": "WR1",
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"$$hashKey": "object:503",
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "avg"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": false,
"colorValue": true,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#AD0317"
],
"datasource": "solaranzeige2",
"decimals": null,
"description": "",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "celsius",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 2,
"x": 13,
"y": 6
},
"id": 28,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:500",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:501",
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "50%",
"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
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "Service",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"Temperatur"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": "35,45,50",
"title": "WR2",
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"$$hashKey": "object:503",
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "avg"
},
{
"columns": [],
"datasource": "solaranzeige1",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fontSize": "110%",
"gridPos": {
"h": 5,
"w": 13,
"x": 0,
"y": 8
},
"id": 6,
"links": [],
"pageSize": 1,
"scroll": false,
"showHeader": true,
"sort": {
"col": 0,
"desc": true
},
"styles": [
{
"$$hashKey": "object:5433",
"alias": "Time",
"align": "auto",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
"$$hashKey": "object:5434",
"alias": "Spannung",
"align": "auto",
"colorMode": "row",
"colors": [
"#1f78c1",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 1,
"mappingType": 1,
"pattern": "Spannung",
"thresholds": [],
"type": "number",
"unit": "volt"
},
{
"$$hashKey": "object:5435",
"alias": " Ladestrom",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Ladestrom",
"thresholds": [],
"type": "number",
"unit": "amp"
},
{
"$$hashKey": "object:5436",
"alias": "Entladung",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Entladung",
"thresholds": [],
"type": "number",
"unit": "amp"
},
{
"$$hashKey": "object:5437",
"alias": "",
"align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 1,
"mappingType": 1,
"pattern": "PV-Watt",
"thresholds": [],
"type": "number",
"unit": "watt"
}
],
"targets": [
{
"alias": "Spannung",
"groupBy": [],
"measurement": "Batterie",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Spannung"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Ladestrom",
"groupBy": [],
"measurement": "Batterie",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Ladestrom"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Entladung",
"groupBy": [],
"measurement": "Batterie",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Entladestrom"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "PV-Watt",
"groupBy": [],
"measurement": "PV",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Leistung"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"title": "Batteriewerte",
"transform": "timeseries_to_columns",
"transparent": true,
"type": "table-old"
},
{
"cacheTimeout": null,
"colorBackground": true,
"colorValue": false,
"colors": [
"#299c46",
"#bf1b00",
"#1f78c1"
],
"datasource": "solaranzeige1",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "none",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 4,
"x": 13,
"y": 8
},
"hideTimeOverride": false,
"id": 19,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:6067",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:6068",
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(252, 226, 222, 0)",
"full": false,
"lineColor": "#3f6833",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "Service",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT \"Device_Status\" FROM \"Service\" WHERE $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Device_Status"
],
"type": "field"
}
]
],
"tags": []
}
],
"thresholds": "4,5",
"timeFrom": null,
"title": "",
"transparent": true,
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"$$hashKey": "object:6070",
"op": "=",
"text": "WR1 unbekannt",
"value": "0"
},
{
"$$hashKey": "object:6071",
"op": "=",
"text": "WR1 Power ON",
"value": "1"
},
{
"$$hashKey": "object:6072",
"op": "=",
"text": "WR1 Stand by Mode",
"value": "2"
},
{
"$$hashKey": "object:6073",
"op": "=",
"text": "WR1 Batterie Mode",
"value": "3"
},
{
"$$hashKey": "object:6074",
"op": "=",
"text": "WR1 Netz Mode",
"value": "4"
},
{
"$$hashKey": "object:6075",
"op": "=",
"text": "WR1 Fehler Mode",
"value": "5"
},
{
"$$hashKey": "object:6076",
"op": "=",
"text": "WR1 ECO Mode",
"value": "6"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": true,
"colorValue": false,
"colors": [
"#299c46",
"#bf1b00",
"#1f78c1"
],
"datasource": "solaranzeige2",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "none",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 4,
"x": 13,
"y": 10
},
"hideTimeOverride": false,
"id": 8,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:6236",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:6237",
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(252, 226, 222, 0)",
"full": false,
"lineColor": "#3f6833",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "Service",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"Device_Status\") FROM \"Service\" WHERE $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Device_Status"
],
"type": "field"
}
]
],
"tags": []
}
],
"thresholds": "4,5",
"timeFrom": null,
"title": "",
"transparent": true,
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"$$hashKey": "object:6239",
"op": "=",
"text": "WR2 unbekannt",
"value": "0"
},
{
"$$hashKey": "object:6240",
"op": "=",
"text": "WR2 Power ON",
"value": "1"
},
{
"$$hashKey": "object:6241",
"op": "=",
"text": "WR2 Stand by Mode",
"value": "2"
},
{
"$$hashKey": "object:6242",
"op": "=",
"text": "WR2 Batterie Mode",
"value": "3"
},
{
"$$hashKey": "object:6243",
"op": "=",
"text": "WR2 Netz Mode",
"value": "4"
},
{
"$$hashKey": "object:6244",
"op": "=",
"text": "WR2 Fehler Mode",
"value": "5"
},
{
"$$hashKey": "object:6245",
"op": "=",
"text": "WR2 ECO Mode",
"value": "6"
}
],
"valueName": "current"
},
{
"content": "\n\n\n\n\n\n