DRAZimm Geschrieben December 13, 2024 at 07:53 Geschrieben December 13, 2024 at 07:53 Hallo zusammen, hat jemand bereits ein Grafana Dashboard für die WARP3 geschrieben und mag es teilen? Falls nein, besteht Interesse an einem Dashboard? Ich würde dann ein anfangen eins zu schreiben und mit der Community teilen. Grüße Alex Zitieren
DRAZimm Geschrieben December 29, 2024 at 16:56 Autor Geschrieben December 29, 2024 at 16:56 Es hat sich zwar noch keiner gemeldet, aber immerhin gab es ein paar Aufrufe des Post. Also ein bisschen Interesse ist da :-) Sobald das Dashboard vorzeigbar ist, werde ich es gerne hier teilen. PS: Ich lesen das MQTT Topic via telegraf aus. Im Moment scheitere ich daran das JSON Array für die 30 letzten Ladevorgangänge zu parsen. Siehe hier. Falls mich jemand beim Debuggen unterstützen möchte, kann er sich gerne melden. Frohe Feiertage Alex Zitieren
DRAZimm Geschrieben January 5, 2025 at 21:37 Autor Geschrieben January 5, 2025 at 21:37 Hallo zusammen, anbei der Screenshot des Grafana Dashboards. Realisiert via Warp MQTT > Mosquitto > Telegraf > InfluxDB > Grafana. Vor allem das MQTT Parsing mit Telegraf hat mich Nerven gekostet :-) Falls jemand Interesse hat, kann er sich gerne melden. Alex Zitieren
E1337E Geschrieben April 5, 2025 at 19:13 Geschrieben April 5, 2025 at 19:13 Hi, hab den Beitrag erst jetzt gefunden. Ich würde gern mal testen, ob das Dashboard auch noch für den Warp1 Pro funktioniert. Grüße, Maik Zitieren
TMA84 Geschrieben May 7, 2025 at 18:07 Geschrieben May 7, 2025 at 18:07 Mich würde das Dashboard auch interessieren Zitieren
DRAZimm Geschrieben May 8, 2025 at 14:05 Autor Geschrieben May 8, 2025 at 14:05 Bitte ;-) Grafana Dashboard Zitieren
universal-dilettant Geschrieben July 17, 2025 at 02:57 Geschrieben July 17, 2025 at 02:57 Am 8.5.2025 um 16:05 schrieb DRAZimm: Bitte ;-) Grafana Dashboard Hättest du auch noch die telegraf config? Dankeschön 😁 Zitieren
DRAZimm Geschrieben July 20, 2025 at 16:56 Autor Geschrieben July 20, 2025 at 16:56 Sorry, für die späte Antwort. Hatte es vergessen. telegarf config 1 Zitieren
DRAZimm Geschrieben July 20, 2025 at 16:59 Autor Geschrieben July 20, 2025 at 16:59 Das Grafana Dashboard hatte auch noch einen Fehler. Bei mir steht bei "Ladevorgänge aktueller Monat" und "Ladevorgänge letzter Monat" immer 0. Da muss ich mal nachschauen Zitieren
Fugazzy Geschrieben September 10, 2025 at 06:07 Geschrieben September 10, 2025 at 06:07 Am 20.7.2025 um 18:59 schrieb DRAZimm: Das Grafana Dashboard hatte auch noch einen Fehler. Bei mir steht bei "Ladevorgänge aktueller Monat" und "Ladevorgänge letzter Monat" immer 0. Da muss ich mal nachschauen Gibt es hierzu Neuigkeiten? Ich noch sehr unbewandert in influx / grafana / telegraf, aber habe inzwischen die Adaption des Dashbords auf mein System hinbekommen. Vielen Dank für die Bereitstellung!! Leider bleiben die Felder "Ladevorgänge aktueller Monat" und "Ladevorgänge letzter Monat" leer, bzw. zeigen "no data" an. Für einen Tipp, was ich anpassen sollte, wäre ich sehr dankbar. Zitieren
DRAZimm Geschrieben September 10, 2025 at 06:32 Autor Geschrieben September 10, 2025 at 06:32 Ich glaube, ich hab das lokal bei mir gefixt. Ich muss mal nachschauen. Bin gerade beruflich unterwegs. Ich kann morgen oder Freitag nachschauen. Wenn ich dich "vergessen" sollte, dann ginge mich am WE nochmals an. Grüße Alex 1 Zitieren
Fugazzy Geschrieben September 15, 2025 at 07:27 Geschrieben September 15, 2025 at 07:27 Am 10.9.2025 um 08:32 schrieb DRAZimm: Ich glaube, ich hab das lokal bei mir gefixt. Ich muss mal nachschauen. Bin gerade beruflich unterwegs. Ich kann morgen oder Freitag nachschauen. Wenn ich dich "vergessen" sollte, dann ginge mich am WE nochmals an. Ping ;-) Zitieren
DRAZimm Geschrieben September 15, 2025 at 11:59 Autor Geschrieben September 15, 2025 at 11:59 { "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": 50, "links": [], "panels": [ { "collapsed": false, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 7, "panels": [], "title": "Zustände", "type": "row" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { "0": { "color": "blue", "index": 0, "text": "Nicht verbunden" }, "1": { "color": "orange", "index": 1, "text": "Warte auf Ladefreigabe" }, "2": { "color": "yellow", "index": 2, "text": "Ladebereit" }, "3": { "color": "green", "index": 3, "text": "Lädt" }, "4": { "color": "red", "index": 4, "text": "Fehler" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 1 }, "id": 2, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": { "valueSize": 36 }, "textMode": "auto", "wideLayout": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"charger_state\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)", "refId": "A" } ], "title": "Ladecontroller", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { "0": { "color": "green", "index": 0, "text": "OK" }, "2": { "color": "red", "index": 1, "text": "Schalterfehler" }, "3": { "color": "red", "index": 2, "text": "DC-Überwachungsfehler" }, "4": { "color": "red", "index": 3, "text": "Schützfehler" }, "5": { "color": "red", "index": 4, "text": "Kommunikationsfehler" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 4, "y": 1 }, "id": 3, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": { "valueSize": 36 }, "textMode": "auto", "wideLayout": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"error_state\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)", "refId": "A" } ], "title": "Fehlerzustand", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisPlacement": "auto", "fillOpacity": 70, "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineWidth": 1 }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "error_state" }, "properties": [ { "id": "displayName", "value": "Fehlerzustand" }, { "id": "mappings", "value": [ { "options": { "0": { "color": "green", "index": 0, "text": "OK" }, "2": { "color": "red", "index": 1, "text": "Schalterfehler" }, "3": { "color": "red", "index": 2, "text": "DC-Überwachungsfehler" }, "4": { "color": "red", "index": 3, "text": "Schützfehler" }, "5": { "color": "red", "index": 4, "text": "Kommunikationsfehler" } }, "type": "value" } ] } ] }, { "matcher": { "id": "byName", "options": "dc_fault_current_state" }, "properties": [ { "id": "displayName", "value": "DC-Fehler" }, { "id": "mappings", "value": [ { "options": { "0": { "color": "green", "index": 0, "text": "OK" }, "1": { "color": "red", "index": 1, "text": "6 mA Fehlerstrom" }, "2": { "color": "red", "index": 2, "text": "Systemfehler" }, "3": { "color": "red", "index": 3, "text": "Unbekannter Fehler" }, "4": { "color": "red", "index": 4, "text": "Kalibrierungsfehler" }, "5": { "color": "red", "index": 5, "text": "AC-Fehler" }, "6": { "color": "red", "index": 6, "text": "AC- & DC-Fehler" } }, "type": "value" } ] } ] }, { "matcher": { "id": "byName", "options": "contactor_error" }, "properties": [ { "id": "displayName", "value": "Schützfehler" }, { "id": "mappings", "value": [ { "options": { "0": { "color": "green", "index": 0, "text": "OK" }, "1": { "color": "red", "index": 1, "text": "L2+L3 nicht geschaltet" }, "2": { "color": "red", "index": 2, "text": "L1+N nicht geschaltet" }, "3": { "color": "red", "index": 3, "text": "2 Schütze nicht geschaltet" }, "8": { "color": "red", "index": 6, "text": "L1+N geschaltet" }, "9": { "color": "red", "index": 7, "text": "L2+L3 geschaltet" }, "10": { "color": "red", "index": 8, "text": "2 Schütze geschaltet" }, "11": { "color": "red", "index": 9, "text": "L1+N geschaltet" }, "12": { "color": "red", "index": 10, "text": "L2+L3 geschaltet" } }, "type": "value" }, { "options": { "from": 4, "result": { "color": "red", "index": 4, "text": "L2+L3 geschaltet" }, "to": 5 }, "type": "range" }, { "options": { "from": 6, "result": { "color": "red", "index": 5, "text": "2 Schütze geschaltet" }, "to": 7 }, "type": "range" } ] } ] } ] }, "gridPos": { "h": 8, "w": 16, "x": 8, "y": 1 }, "hideTimeOverride": true, "id": 5, "options": { "colWidth": 0.9, "legend": { "displayMode": "list", "placement": "bottom", "showLegend": true }, "rowHeight": 0.9, "showValue": "never", "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "query": "import \"timezone\"\nimport \"date\"\n\noption location = timezone.location(name: \"Europe/Berlin\")\n\ntempTime = date.truncate(t: now(), unit: 1h)\n\nfrom(bucket: \"telegraf/autogen\")\n |> range(start: date.sub(from: tempTime, d: 12h), stop: tempTime)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"error_state\" or r[\"_field\"] == \"contactor_error\" or r[\"_field\"] == \"dc_fault_current_state\")\n |> aggregateWindow(every: 1h, offset: -1h, fn:last, createEmpty: false)", "refId": "A" } ], "timeFrom": "now-12h", "title": "Fehlerstatus über Zeit", "type": "status-history" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { "0": { "color": "green", "index": 0, "text": "OK" }, "1": { "color": "red", "index": 1, "text": "6 mA Fehlerstrom" }, "2": { "color": "red", "index": 2, "text": "Systemfehler" }, "3": { "color": "red", "index": 3, "text": "Unbekannter Fehler" }, "4": { "color": "red", "index": 4, "text": "Kalibrierungsfehler" }, "5": { "color": "red", "index": 5, "text": "AC-Fehler" }, "6": { "color": "red", "index": 6, "text": "AC- & DC-Fehler" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 5 }, "id": 4, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": { "valueSize": 36 }, "textMode": "auto", "wideLayout": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"dc_fault_current_state\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)", "refId": "A" } ], "title": "DC-Fehler", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { "0": { "color": "green", "index": 0, "text": "OK" }, "1": { "color": "red", "index": 1, "text": "L2+L3 nicht geschaltet" }, "2": { "color": "red", "index": 2, "text": "L1+N nicht geschaltet" }, "3": { "color": "red", "index": 3, "text": "2 Schütze nicht geschaltet" }, "8": { "color": "red", "index": 6, "text": "L1+N geschaltet" }, "9": { "color": "red", "index": 7, "text": " L2+L3 geschaltet" }, "10": { "color": "red", "index": 8, "text": "2 Schütze geschaltet" }, "11": { "color": "red", "index": 9, "text": "L1+N geschaltet" }, "12": { "color": "red", "index": 10, "text": "L2+L3 geschaltet" } }, "type": "value" }, { "options": { "from": 4, "result": { "color": "red", "index": 4, "text": "L2+L3 geschaltet" }, "to": 5 }, "type": "range" }, { "options": { "from": 6, "result": { "color": "red", "index": 5, "text": "2 Schütze geschaltet" }, "to": 7 }, "type": "range" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 4, "y": 5 }, "id": 6, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": { "valueSize": 36 }, "textMode": "auto", "wideLayout": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"contactor_error\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)", "refId": "A" } ], "title": "Schützfehler", "type": "stat" }, { "collapsed": true, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 9 }, "id": 8, "panels": [], "title": "Ladevorgänge", "type": "row" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "blue", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 10 }, "id": 9, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": { "valueSize": 36 }, "textMode": "auto", "wideLayout": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"tracked_charges\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)", "refId": "A" } ], "title": "Ladevorgänge Gesamt", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-GrYlRd" }, "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false, "width": 150 }, "mappings": [], "max": 90.6, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time: DD MMM Y" } ] }, { "matcher": { "id": "byName", "options": "charge_duration" }, "properties": [ { "id": "unit", "value": "dtdurations" }, { "id": "displayName", "value": "Ladedauer" } ] }, { "matcher": { "id": "byName", "options": "_value" }, "properties": [ { "id": "custom.cellOptions", "value": { "mode": "lcd", "type": "gauge", "valueDisplayMode": "color" } }, { "id": "displayName", "value": "Energiemenge" }, { "id": "unit", "value": "kwatt" }, { "id": "custom.width", "value": 200 } ] }, { "matcher": { "id": "byName", "options": "_cost" }, "properties": [ { "id": "unit", "value": "currencyEUR" }, { "id": "decimals", "value": 2 }, { "id": "custom.cellOptions", "value": { "mode": "basic", "type": "gauge", "valueDisplayMode": "color" } }, { "id": "displayName", "value": "Kosten" }, { "id": "custom.width", "value": 200 } ] } ] }, "gridPos": { "h": 12, "w": 10, "x": 4, "y": 10 }, "id": 22, "options": { "cellHeight": "sm", "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": true }, "frameIndex": 1, "showHeader": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "import \"timezone\"\nimport \"date\"\n\noption location = timezone.location(name: \"Europe/Berlin\")\n\nfrom(bucket: \"telegraf/autogen\")\n |> range(start: date.truncate(t: now(), unit: 1mo), stop: now())\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"topic\"] == \"warp/charge_tracker/last_charges\")\n |> filter(fn: (r) => r[\"_field\"] == \"charge_duration\")\n |> drop(columns: [\"host\", \"topic\", \"user_id\", \"timestamp\"])", "refId": "A" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "hide": false, "query": "import \"timezone\"\nimport \"date\"\n\noption location = timezone.location(name: \"Europe/Berlin\")\n\nfrom(bucket: \"telegraf/autogen\")\n |> range(start: date.truncate(t: now(), unit: 1mo), stop: now())\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"topic\"] == \"warp/charge_tracker/last_charges\")\n |> filter(fn: (r) => r[\"_field\"] == \"energy_charged\")\n |> drop(columns: [\"host\", \"topic\", \"user_id\", \"timestamp\"])\n |> map(fn: (r) => ({r with _cost: float(v: r._value) * 0.2937}))", "refId": "B" } ], "title": "Ladevorgänge im aktuellen Monat", "transformations": [ { "id": "joinByField", "options": { "mode": "inner" } } ], "type": "table" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-GrYlRd" }, "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false, "width": 150 }, "mappings": [], "max": 90.6, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "unit", "value": "time: DD MMM Y" } ] }, { "matcher": { "id": "byName", "options": "charge_duration" }, "properties": [ { "id": "unit", "value": "dtdurations" }, { "id": "displayName", "value": "Ladedauer" } ] }, { "matcher": { "id": "byName", "options": "_value" }, "properties": [ { "id": "custom.cellOptions", "value": { "mode": "lcd", "type": "gauge", "valueDisplayMode": "color" } }, { "id": "displayName", "value": "Energiemenge" }, { "id": "unit", "value": "kwatt" }, { "id": "custom.width", "value": 200 } ] }, { "matcher": { "id": "byName", "options": "_cost" }, "properties": [ { "id": "unit", "value": "currencyEUR" }, { "id": "decimals", "value": 2 }, { "id": "custom.cellOptions", "value": { "mode": "basic", "type": "gauge", "valueDisplayMode": "color" } }, { "id": "displayName", "value": "Kosten" }, { "id": "custom.width", "value": 200 } ] } ] }, "gridPos": { "h": 12, "w": 10, "x": 14, "y": 10 }, "id": 18, "options": { "cellHeight": "sm", "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": true }, "frameIndex": 1, "showHeader": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "import \"timezone\"\nimport \"date\"\n\noption location = timezone.location(name: \"Europe/Berlin\")\n\nfrom(bucket: \"telegraf/autogen\")\n |> range(start: date.truncate(t: -1mo, unit: 1mo), stop: date.truncate(t: now(), unit: 1mo)) \n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"topic\"] == \"warp/charge_tracker/last_charges\")\n |> filter(fn: (r) => r[\"_field\"] == \"charge_duration\")\n |> drop(columns: [\"host\", \"topic\", \"user_id\", \"timestamp\"])", "refId": "A" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "hide": false, "query": "import \"timezone\"\nimport \"date\"\n\noption location = timezone.location(name: \"Europe/Berlin\")\n\nfrom(bucket: \"telegraf/autogen\")\n |> range(start: date.truncate(t: -1mo, unit: 1mo), stop: date.truncate(t: now(), unit: 1mo)) \n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"topic\"] == \"warp/charge_tracker/last_charges\")\n |> filter(fn: (r) => r[\"_field\"] == \"energy_charged\")\n |> drop(columns: [\"host\", \"topic\", \"user_id\", \"timestamp\"])\n |> map(fn: (r) => ({r with _cost: float(v: r._value) * 0.2937}))", "refId": "B" } ], "title": "Ladevorgänge im letzten Monat", "transformations": [ { "id": "joinByField", "options": { "mode": "inner" } } ], "type": "table" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "blue", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 14 }, "id": 23, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": { "valueSize": 36 }, "textMode": "auto", "wideLayout": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "import \"timezone\"\nimport \"date\"\n\noption location = timezone.location(name: \"Europe/Berlin\")\n\n\nfrom(bucket: \"telegraf/autogen\")\n |> range(start: date.truncate(t: now(), unit: 1mo), stop: now())\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"tracked_charges\")\n |> spread()", "refId": "A" } ], "title": "Ladevorgänge aktueller Monat", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "blue", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 18 }, "id": 24, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "auto", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": { "valueSize": 36 }, "textMode": "auto", "wideLayout": true }, "pluginVersion": "12.1.1", "targets": [ { "query": "import \"timezone\"\nimport \"date\"\n\noption location = timezone.location(name: \"Europe/Berlin\")\n\n from(bucket: \"telegraf/autogen\")\n |> range(start: date.truncate(t: -1mo, unit: 1mo), stop: date.truncate(t: now(), unit: 1mo)) \n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"tracked_charges\")\n |> spread()\n\n\n\n", "refId": "A" } ], "title": "Ladevorgänge letzter Monat", "type": "stat" }, { "collapsed": true, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 22 }, "id": 12, "panels": [], "title": "Außenleiter", "type": "row" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Leistung", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Leistung" }, "properties": [ { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 0, "y": 23 }, "id": 11, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"power_L1\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Leistung L1", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Leistung", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Leistung" }, "properties": [ { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 8, "y": 23 }, "id": 13, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"power_L2\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Leistung L2", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Leistung", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Leistung" }, "properties": [ { "id": "color", "value": { "fixedColor": "yellow", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 16, "y": 23 }, "id": 17, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"power_L3\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Leistung L3", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Stromstärke", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "mamp" }, "overrides": [ { "matcher": { "id": "byName", "options": "Stromstärke" }, "properties": [ { "id": "color", "value": { "fixedColor": "orange", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 0, "y": 31 }, "id": 19, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"current_L1\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Stromstärke L1", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Stromstärke", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "mamp" }, "overrides": [ { "matcher": { "id": "byName", "options": "Stromstärke" }, "properties": [ { "id": "color", "value": { "fixedColor": "orange", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 8, "y": 31 }, "id": 20, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"current_L2\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Stromstärke L2", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Stromstärke", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "mamp" }, "overrides": [ { "matcher": { "id": "byName", "options": "Stromstärke" }, "properties": [ { "id": "color", "value": { "fixedColor": "orange", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 16, "y": 31 }, "id": 21, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"current_L3\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Stromstärke L3", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Spannung", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "volt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Spannung" }, "properties": [ { "id": "color", "value": { "fixedColor": "purple", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 0, "y": 39 }, "id": 14, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"voltage_L1\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Spannung L1", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Spannung", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "volt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Spannung" }, "properties": [ { "id": "color", "value": { "fixedColor": "purple", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 8, "y": 39 }, "id": 15, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"voltage_L2\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Spannung L2", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "barWidthFactor": 0.6, "drawStyle": "line", "fillOpacity": 20, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "Spannung", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": 0 }, { "color": "red", "value": 80 } ] }, "unit": "volt" }, "overrides": [ { "matcher": { "id": "byName", "options": "Spannung" }, "properties": [ { "id": "color", "value": { "fixedColor": "purple", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 8, "w": 8, "x": 16, "y": 39 }, "id": 16, "options": { "legend": { "calcs": [ "min", "mean", "max", "last" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "hideZeros": false, "mode": "single", "sort": "none" } }, "pluginVersion": "12.1.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "sRCk9Y9nk" }, "query": "from(bucket: \"telegraf/autogen\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"warp\")\n |> filter(fn: (r) => r[\"_field\"] == \"voltage_L3\")\n |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)\n |> yield(name: \"last\")", "refId": "A" } ], "title": "Spannung L3", "type": "timeseries" } ], "preload": false, "schemaVersion": 41, "tags": [], "templating": { "list": [] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": {}, "timezone": "browser", "title": "4. WARP Charger", "uid": "be70fzxyksn40b", "version": 49 } Zitieren
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.