-
|
Hallo, Diesen muss ich ja einfach mit der seriellen Schnittstelle des Raspberrys verkabeln und dann noch den Adapter mit den WR, aber wie? Oder brauche ich den Adapter gar nicht? Bzw. wie hast du das ganze verkabelt? Ich habe zwei SunnyBoy 3000. Danke im Voraus! |
Beta Was this translation helpful? Give feedback.
Answered by
chrishrb
Mar 15, 2021
Replies: 10 comments 8 replies
-
|
Ich habe mir damals diesen[1] USB-Adapter geholt und RX/TX/GND entsprechend mit den drei Kabeln aus den WR verbunden. Ich hatte dann direkt ein Device Der erste Schritt wäre bei der vermutlich der gleiche (RX/TX heißen halt A+/A-). Statt per USB musst Du die linke Seite dann noch an den entsprechenden GPIO-Pins (RX/TX/GND/5V) mit Deinem Pi verbinden. Soweit ich weiß gibt es auch für die Pins direkt vorinstallierte Devices[2], über die Du dann mit den WR kommunizieren kannst. Generell würde ich mit dem Zero ein bisschen aufpassen, meines Wissens basiert der auf der selben [1] https://www.amazon.de/-/en/Digitus-USB-to-Serial-Adapter/dp/B007VZY4CW |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
okay, also ich will auf dem raspberry nur yasdi2mqtt laufen lassen, deswegen kein problem. https://files.sma.de/downloads/SB3000-11-EE3801.pdf (seite 55) |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Puh, ich hab damals glaube ich einfach alle 6 Möglichkeiten durchprobiert. Keine Ahnung wie gesund das für alle Beteiligten war. Widerstände habe ich keine drin, soweit ich weiß regelt das alles der RA485-Adapter. Ich bin aber auch kein Elektrotechniker, von daher kann ich da keine fundierte Aussage treffen. Stand jetzt (1 Jahr Betrieb etwa) hatte ich jedenfalls noch keinen einzigen Fehler. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Gerade erst einen Blick in die PDF geworfen, vorausgesetzt das korrekte PiggyBack ist installiert, gibt Seite 52 dann nicht die korrekte Verkabelung vor? |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Ich will es über RS485 laufen lassen (also alle WR in einem Bus) also nein, nicht ganz. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Ach ja, das mit RS232 habe ich übersehen, bei mir ist auch RS485 mit 2 WR am Start. Ja, bei mir sind die WR direkt mit dem Adapter verbunden. Allerdings ist ja ein Breakout-Board vorgeschaltet (siehe Amazon-Foto), keine Ahnung ob es das vielleicht schon macht. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Bei mir ist es
Der Aufbau ist wie in den SMA Dokumenten gefordert RS485 daisy-chained. Ich habe auch so einige SMA Dokumente gelesen, in jedem habe ich etwas gefunden, das mein Verständnis des Setups verbessert hat 😅 RasPi -> USB zu RS485 Konverter -> Inverter 1 -> Inverter 2 -> Inverter 3 -> Inverter 4 Inverter 4: Jumper zum Terminieren des RS485 BUS gesetzt Ich habe absolut null Erfahrung mit seriellen Schnittstellen bzw. Eletronik in diesem Bereich und mein Bauchgefühl ist, dass es ein billigeres Datenkabel auch getan hätte. Trotzdem hat es auf Anhieb geklappt und läuft ohne Probleme seit vielleicht 1-2 Jahren. Natürlich habe ich vorher mit dem Elektriker, der die Anlage installiert hat gesprochen was ich beachten muss, damit das ganze ungefährlich bleibt. Letztendlich habe ich die Sicherungen der Wechselrichter ausgeschaltet, die Verkabelung zu den Solarmodulen getrennt und eine Weile gewartet damit sich Kondensatoren entladen können und was weiß ich. Erdung und Kabelschlauch für das Datenkabel habe ich bis heute immer noch nicht gemacht, das sollte ich echt mal nachholen. Habt ihr das gemacht bzw. vor? |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Danke für die Details. Zu der letzten Frage kann ich gar nicht viel sagen, die Anlage steht im Haus meiner Eltern - die haben das damals alles von einem Elektriker einbauen lassen. Wegen Covid war ich allerdings schon länger nicht mehr vor Ort und kann deshalb nicht mehr sagen, als dass drei Kabel für RX/TX/GND aus einem der beiden WR ausgeführt sind 😄 |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
also für alle, die auch vorhaben, den adapter zu kaufen, den ich zuerst gekauft habe: macht es NICHT. Ich habe Ewigkeiten rumprobiert, es wollte einfach nicht funktionieren - und habe dann doch noch einen USB-Adapter (den von pkwagner) gekauft. |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
pkwagner
-
|
Sehr schön, freut mich! Aus reiner Neugier: Wie schaut der Postprocessing-Stack eigentlich bei Dir aus? Ich hatte das für mich mal grob hier[1] skizziert (TL;DR: [1] #2 (comment) |
Beta Was this translation helpful? Give feedback.
8 replies
-
|
Nice, das Feature kannte ich tatsächlich noch gar nicht 👍 |
Beta Was this translation helpful? Give feedback.
-
|
kannst du ja dann evtl. doch noch sharen, vll sogar ins repo mit aufnehmen.. würde den anderen (und mir 🤣 ) beim post-processing helfen |
Beta Was this translation helpful? Give feedback.
-
|
Haha ja klar, hier die drei Dashboards. Ich hatte tatsächlich mal überlegt einen Medium-Post oder zumindest eine Wiki-Page zu meinem Aufbau anzulegen, bin aber bisher noch nicht so richtig dazu gekommen. Tagesansicht{
"__inputs": [
{
"name": "DS_INFLUXDB",
"label": "InfluxDB",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
},
{
"name": "VAR_PRICE",
"type": "constant",
"label": "Euro / kWh",
"value": "0.49",
"description": ""
}
],
"__requires": [
{
"type": "panel",
"id": "gauge",
"name": "Gauge",
"version": ""
},
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "7.3.6"
},
{
"type": "panel",
"id": "graph",
"name": "Graph",
"version": ""
},
{
"type": "datasource",
"id": "influxdb",
"name": "InfluxDB",
"version": "1.0.0"
},
{
"type": "panel",
"id": "singlestat",
"name": "Singlestat",
"version": ""
},
{
"type": "panel",
"id": "stat",
"name": "Stat",
"version": ""
},
{
"type": "panel",
"id": "table-old",
"name": "Table (old)",
"version": ""
}
],
"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": null,
"iteration": 1615910690141,
"links": [],
"panels": [
{
"alert": {
"alertRuleTags": {},
"conditions": [
{
"evaluator": {
"params": [],
"type": "no_value"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"A",
"24h",
"now"
]
},
"reducer": {
"params": [],
"type": "last"
},
"type": "query"
},
{
"evaluator": {
"params": [],
"type": "no_value"
},
"operator": {
"type": "or"
},
"query": {
"params": [
"B",
"24h",
"now"
]
},
"reducer": {
"params": [],
"type": "last"
},
"type": "query"
}
],
"executionErrorState": "alerting",
"for": "0m",
"frequency": "1d",
"handler": 1,
"message": "Ding Dong, der Wechselrichter ist vielleicht ausgefallen.",
"name": "Ausfallmeldung",
"noDataState": "alerting",
"notifications": [
{
"uid": "9BOuM_zRk"
}
]
},
"aliasColors": {
"Verbrauch": "yellow",
"WR I": "rgb(199, 199, 199)",
"WR II": "rgb(255, 255, 255)"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {},
"links": []
},
"overrides": []
},
"fill": 10,
"fillGradient": 0,
"gridPos": {
"h": 13,
"w": 24,
"x": 0,
"y": 0
},
"hiddenSeries": false,
"id": 2,
"legend": {
"alignAsTable": true,
"avg": true,
"current": false,
"max": true,
"min": true,
"rightSide": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 0,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.6",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"$$hashKey": "object:242",
"alias": "Verbrauch",
"stack": false
}
],
"spaceLength": 10,
"stack": true,
"steppedLine": false,
"targets": [
{
"alias": "WR I",
"groupBy": [
{
"params": [
"30s"
],
"type": "time"
}
],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Pac"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "WR II",
"groupBy": [
{
"params": [
"30s"
],
"type": "time"
}
],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Pac"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Verbrauch",
"groupBy": [],
"measurement": "electricity_15s",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"current\") * -1 FROM \"electricity_15s\" WHERE $timeFilter GROUP BY time(15s)",
"rawQuery": false,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"current"
],
"type": "field"
},
{
"params": [
"* -1"
],
"type": "math"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Leistung AC",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:439",
"format": "watt",
"label": null,
"logBase": 1,
"max": "7000",
"min": "-7000",
"show": true
},
{
"$$hashKey": "object:440",
"format": "percent",
"label": null,
"logBase": 1,
"max": "100",
"min": "0",
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {},
"decimals": 2,
"mappings": [],
"max": 3500,
"min": 0,
"noValue": "0 W",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(255, 255, 255)",
"value": null
},
{
"color": "semi-dark-red",
"value": 3000
}
]
},
"unit": "watt"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Verbrauch"
},
"properties": [
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "yellow",
"value": null
}
]
}
}
]
}
]
},
"gridPos": {
"h": 6,
"w": 14,
"x": 0,
"y": 13
},
"hideTimeOverride": true,
"id": 7,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": true
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "7.3.6",
"targets": [
{
"alias": "Verbrauch",
"groupBy": [],
"measurement": "electricity_1s",
"orderByTime": "ASC",
"policy": "few_days",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"current"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "WR I",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Pac"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "WR II",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Pac"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
}
],
"timeFrom": "45s",
"timeShift": null,
"title": "Letzte Leistung AC",
"type": "gauge"
},
{
"columns": [],
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fontSize": "100%",
"gridPos": {
"h": 10,
"w": 5,
"x": 14,
"y": 13
},
"hideTimeOverride": true,
"id": 4,
"pageSize": null,
"showHeader": true,
"sort": {
"col": 0,
"desc": true
},
"styles": [
{
"alias": "Time",
"align": "auto",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
"alias": "",
"align": "left",
"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,
"link": false,
"mappingType": 1,
"pattern": "Value",
"thresholds": [],
"type": "number",
"unit": "none"
},
{
"alias": "",
"align": "right",
"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": "Metric",
"thresholds": [],
"type": "string",
"unit": "short"
}
],
"targets": [
{
"alias": "Fehler",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Fehler"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "Status",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Status"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "Netzfrequenz AC (Hz)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Fac"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "Spannung AC (V)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Uac"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "Spannung DC (V)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Upv-Ist"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "Leistung DC (W)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "H",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_PPV"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "Betriebsdauer (h)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "G",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_h-Total"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "Gesamtleistung AC (kWh)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_E-Total"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
}
],
"timeFrom": "45s",
"timeShift": null,
"title": "Letzte Statuswerte (WR I)",
"transform": "timeseries_to_rows",
"type": "table-old"
},
{
"columns": [],
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fontSize": "100%",
"gridPos": {
"h": 10,
"w": 5,
"x": 19,
"y": 13
},
"hideTimeOverride": true,
"id": 5,
"pageSize": null,
"showHeader": true,
"sort": {
"col": 0,
"desc": true
},
"styles": [
{
"alias": "Time",
"align": "auto",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
"alias": "",
"align": "left",
"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,
"link": false,
"mappingType": 1,
"pattern": "Value",
"thresholds": [],
"type": "number",
"unit": "none"
},
{
"alias": "",
"align": "right",
"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": "Metric",
"thresholds": [],
"type": "string",
"unit": "short"
}
],
"targets": [
{
"alias": "Fehler",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Fehler"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Status",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Status"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Netzfrequenz AC (Hz)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Fac"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Spannung AC (V)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Uac"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Spannung DC (V)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_Upv-Ist"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Leistung DC (W)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "H",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_PPV"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Betriebsdauer (h)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "G",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_h-Total"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Gesamtleistung AC (kWh)",
"groupBy": [],
"measurement": "solar_15s",
"orderByTime": "ASC",
"policy": "default",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"values_E-Total"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
}
],
"timeFrom": "45s",
"timeShift": null,
"title": "Letzte Statuswerte (WR II)",
"transform": "timeseries_to_rows",
"type": "table-old"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(255, 255, 255)",
"value": null
}
]
},
"unit": "watth"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Verbrauch"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 4,
"w": 7,
"x": 0,
"y": 19
},
"id": 11,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "value_and_name"
},
"pluginVersion": "7.3.6",
"targets": [
{
"alias": "Verbrauch",
"groupBy": [],
"measurement": "electricity_5m",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"total"
],
"type": "field"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"/ 12"
],
"type": "math"
}
]
],
"tags": []
},
{
"alias": "Einspeisung",
"groupBy": [],
"measurement": "solar_5m",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"/ 12"
],
"type": "math"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Tagesleistung",
"transformations": [],
"type": "stat"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "green",
"value": 0
}
]
},
"unit": "watth"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 4,
"x": 7,
"y": 19
},
"id": 12,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "value_and_name"
},
"pluginVersion": "7.3.6",
"targets": [
{
"alias": "Verbrauch",
"groupBy": [
{
"params": [
"5m"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "electricity_5m",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"total"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"/ 12"
],
"type": "math"
}
]
],
"slimit": "",
"tags": []
},
{
"alias": "Einspeisung",
"groupBy": [
{
"params": [
"5m"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "solar_5m",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT cumulative_sum(sum(\"Pac\")) / 12 / 1000 FROM \"solar_5m\" WHERE $timeFilter GROUP BY time(5m) fill(0)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [],
"type": "cumulative_sum"
},
{
"params": [
"/ 12"
],
"type": "math"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Bilanz",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Bilanz",
"binary": {
"left": "Einspeisung",
"operator": "-",
"reducer": "sum",
"right": "Verbrauch"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": true
}
}
],
"type": "stat"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"rgb(255, 255, 255)",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": "${DS_INFLUXDB}",
"decimals": 2,
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 3,
"x": 11,
"y": 19
},
"id": 9,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"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,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "solar_5m",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
" / 12 / 1000 * $price"
],
"type": "math"
}
]
],
"tags": []
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Ertrag",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [],
"valueName": "avg"
}
],
"refresh": "5s",
"schemaVersion": 26,
"style": "dark",
"tags": [],
"templating": {
"list": [
{
"current": {
"value": "${VAR_PRICE}",
"text": "${VAR_PRICE}",
"selected": false
},
"error": null,
"hide": 2,
"label": "Euro / kWh",
"name": "price",
"options": [
{
"value": "${VAR_PRICE}",
"text": "${VAR_PRICE}",
"selected": false
}
],
"query": "${VAR_PRICE}",
"skipUrlSync": false,
"type": "constant"
}
]
},
"time": {
"from": "now/d",
"to": "now/d"
},
"timepicker": {
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
]
},
"timezone": "",
"title": "Tagesansicht",
"uid": "3UucuQzRz",
"version": 71
}Monatsansicht{
"__inputs": [
{
"name": "DS_INFLUXDB",
"label": "InfluxDB",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
},
{
"name": "VAR_PRICE",
"type": "constant",
"label": "Euro / kWh",
"value": "0.49",
"description": ""
}
],
"__requires": [
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "7.3.6"
},
{
"type": "panel",
"id": "graph",
"name": "Graph",
"version": ""
},
{
"type": "datasource",
"id": "influxdb",
"name": "InfluxDB",
"version": "1.0.0"
},
{
"type": "panel",
"id": "singlestat",
"name": "Singlestat",
"version": ""
},
{
"type": "panel",
"id": "stat",
"name": "Stat",
"version": ""
}
],
"annotations": {
"list": [
{
"$$hashKey": "object:303",
"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": null,
"iteration": 1615910745989,
"links": [],
"panels": [
{
"aliasColors": {
"Bewölkungsgrad": "dark-blue",
"Verbrauch": "yellow",
"WR I": "rgb(199, 199, 199)",
"WR II": "rgb(255, 255, 255)",
"electricity_5m.sum": "yellow"
},
"bars": true,
"dashLength": 10,
"dashes": false,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {},
"links": []
},
"overrides": []
},
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 19,
"w": 24,
"x": 0,
"y": 0
},
"hiddenSeries": false,
"id": 2,
"legend": {
"alignAsTable": true,
"avg": true,
"current": false,
"max": true,
"min": true,
"rightSide": false,
"show": true,
"total": true,
"values": true
},
"lines": false,
"linewidth": 3,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.6",
"pointradius": 3,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"$$hashKey": "object:362",
"alias": "Bewölkungsgrad",
"bars": false,
"points": true,
"stack": false,
"yaxis": 2
},
{
"$$hashKey": "object:253",
"alias": "Verbrauch",
"bars": false,
"lines": true,
"stack": false
}
],
"spaceLength": 10,
"stack": true,
"steppedLine": true,
"targets": [
{
"alias": "WR I",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
}
],
"measurement": "solar_5m",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
" / 12"
],
"type": "math"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "WR II",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
}
],
"measurement": "solar_5m",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
" / 12"
],
"type": "math"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Verbrauch",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
}
],
"measurement": "electricity_5m",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"total"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
" / 12"
],
"type": "math"
}
]
],
"tags": []
},
{
"alias": "Bewölkungsgrad",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
}
],
"measurement": "weather_1d",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"clouds"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Total AC",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:434",
"format": "watth",
"label": null,
"logBase": 1,
"max": "50000",
"min": "0",
"show": true
},
{
"$$hashKey": "object:435",
"format": "percent",
"label": "",
"logBase": 1,
"max": "100",
"min": "0",
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "green",
"value": 0
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 12,
"x": 0,
"y": 19
},
"id": 6,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "value_and_name"
},
"pluginVersion": "7.3.6",
"targets": [
{
"alias": "Verbrauch",
"groupBy": [],
"measurement": "electricity_1d",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"total"
],
"type": "field"
},
{
"params": [],
"type": "cumulative_sum"
}
]
],
"slimit": "",
"tags": []
},
{
"alias": "Einspeisung",
"groupBy": [],
"measurement": "solar_1d",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT cumulative_sum(sum(\"Pac\")) / 12 / 1000 FROM \"solar_5m\" WHERE $timeFilter GROUP BY time(5m) fill(0)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "cumulative_sum"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Bilanz",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Bilanz",
"binary": {
"left": "Einspeisung",
"operator": "-",
"reducer": "sum",
"right": "Verbrauch"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": true
}
}
],
"type": "stat"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"rgb(255, 255, 255)",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": "${DS_INFLUXDB}",
"decimals": 2,
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 12,
"x": 12,
"y": 19
},
"id": 4,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"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,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "solar_5m",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
" / 12 / 1000 * $price"
],
"type": "math"
}
]
],
"tags": []
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Ertrag",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [],
"valueName": "avg"
}
],
"refresh": "5s",
"schemaVersion": 26,
"style": "dark",
"tags": [],
"templating": {
"list": [
{
"current": {
"value": "${VAR_PRICE}",
"text": "${VAR_PRICE}",
"selected": false
},
"error": null,
"hide": 2,
"label": "Euro / kWh",
"name": "price",
"options": [
{
"value": "${VAR_PRICE}",
"text": "${VAR_PRICE}",
"selected": false
}
],
"query": "${VAR_PRICE}",
"skipUrlSync": false,
"type": "constant"
}
]
},
"time": {
"from": "now/M",
"to": "now/M"
},
"timepicker": {
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
]
},
"timezone": "",
"title": "Monatsansicht",
"uid": "x_w6qzmgk",
"version": 14
}Jahresansicht{
"__inputs": [
{
"name": "DS_INFLUXDB",
"label": "InfluxDB",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
},
{
"name": "VAR_PRICE",
"type": "constant",
"label": "Euro / kWh",
"value": "0.49",
"description": ""
}
],
"__requires": [
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "7.3.6"
},
{
"type": "panel",
"id": "graph",
"name": "Graph",
"version": ""
},
{
"type": "datasource",
"id": "influxdb",
"name": "InfluxDB",
"version": "1.0.0"
},
{
"type": "panel",
"id": "singlestat",
"name": "Singlestat",
"version": ""
},
{
"type": "panel",
"id": "stat",
"name": "Stat",
"version": ""
}
],
"annotations": {
"list": [
{
"$$hashKey": "object:160",
"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": null,
"iteration": 1615910761235,
"links": [],
"panels": [
{
"aliasColors": {
"Einspeisung": "rgb(255, 255, 255)",
"Einspeisung Total": "rgb(255, 255, 255)",
"Verbrauch": "yellow",
"WR I": "dark-red",
"WR II": "dark-green"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {},
"links": []
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 19,
"w": 24,
"x": 0,
"y": 0
},
"hiddenSeries": false,
"id": 2,
"legend": {
"alignAsTable": true,
"avg": true,
"current": false,
"max": true,
"min": true,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.6",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"$$hashKey": "object:228",
"alias": "Verbrauch",
"fill": 0,
"linewidth": 2
},
{
"$$hashKey": "object:500",
"alias": "Einspeisung Total",
"fill": 0,
"linewidth": 2
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": true,
"targets": [
{
"alias": "WR I",
"groupBy": [
{
"params": [
"14d"
],
"type": "time"
}
],
"measurement": "solar_1d",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100140486"
}
]
},
{
"alias": "WR II",
"groupBy": [
{
"params": [
"14d"
],
"type": "time"
}
],
"measurement": "solar_1d",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "sn",
"operator": "=",
"value": "1100142366"
}
]
},
{
"alias": "Verbrauch",
"groupBy": [
{
"params": [
"14d"
],
"type": "time"
}
],
"measurement": "electricity_1d",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"total"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Leistung AC / 14-Tage-Durchschnitt",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Einspeisung Total",
"mode": "reduceRow",
"reduce": {
"include": [
"WR II",
"WR I"
],
"reducer": "sum"
}
}
}
],
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:279",
"format": "kwatth",
"label": "Ø kWh / Tag",
"logBase": 1,
"max": "40",
"min": "0",
"show": true
},
{
"$$hashKey": "object:280",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"custom": {
"align": null,
"filterable": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "green",
"value": 0
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 12,
"x": 0,
"y": 19
},
"id": 6,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "value_and_name"
},
"pluginVersion": "7.3.6",
"targets": [
{
"alias": "Verbrauch",
"groupBy": [],
"measurement": "electricity_1d",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"total"
],
"type": "field"
},
{
"params": [],
"type": "cumulative_sum"
}
]
],
"slimit": "",
"tags": []
},
{
"alias": "Einspeisung",
"groupBy": [],
"measurement": "solar_1d",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT cumulative_sum(sum(\"Pac\")) / 12 / 1000 FROM \"solar_5m\" WHERE $timeFilter GROUP BY time(5m) fill(0)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "cumulative_sum"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Bilanz",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Bilanz",
"binary": {
"left": "Einspeisung",
"operator": "-",
"reducer": "sum",
"right": "Verbrauch"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
},
"replaceFields": true
}
}
],
"type": "stat"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"rgb(255, 255, 255)",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": "${DS_INFLUXDB}",
"decimals": 2,
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 12,
"x": 12,
"y": 19
},
"id": 4,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"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,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "solar_1d",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"Pac"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
" * $price"
],
"type": "math"
}
]
],
"tags": []
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Ertrag",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [],
"valueName": "avg"
}
],
"schemaVersion": 26,
"style": "dark",
"tags": [],
"templating": {
"list": [
{
"current": {
"value": "${VAR_PRICE}",
"text": "${VAR_PRICE}",
"selected": false
},
"error": null,
"hide": 2,
"label": "Euro / kWh",
"name": "price",
"options": [
{
"value": "${VAR_PRICE}",
"text": "${VAR_PRICE}",
"selected": false
}
],
"query": "${VAR_PRICE}",
"skipUrlSync": false,
"type": "constant"
}
]
},
"time": {
"from": "now/y",
"to": "now/y"
},
"timepicker": {
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
]
},
"timezone": "",
"title": "Jahresansicht",
"uid": "c0-5Z8zRk",
"version": 10
} |
Beta Was this translation helpful? Give feedback.
-
|
danke dir! für die |
Beta Was this translation helpful? Give feedback.
-
|
Ja genau, die sind für das tägliche / fünfminütliche Downsampling da. Die Electricity-Daten (1s) haben zusätzlich noch ein Verfallsdatum (3 Tage oder so), die Solardaten (15s) bleiben alle gespeichert. |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
also für alle, die auch vorhaben, den adapter zu kaufen, den ich zuerst gekauft habe: macht es NICHT. Ich habe Ewigkeiten rumprobiert, es wollte einfach nicht funktionieren - und habe dann doch noch einen USB-Adapter (den von pkwagner) gekauft.
Einstecken, starten und hat sofort funktioniert! Danke nochmals, an euch - ihr habt mir sehr geholfen.