#######Diese Zeile entfernen##### { "__inputs": [ { "name": "DS_IOBROKER-DB", "label": "ioBroker-DB", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "barchart", "name": "Bar chart", "version": "" }, { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "9.1.0" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": null, "links": [ { "asDropdown": false, "icon": "external link", "includeVars": false, "keepTime": false, "tags": [], "targetBlank": false, "title": "New link", "tooltip": "", "type": "dashboards", "url": "" } ], "liveNow": false, "panels": [ { "collapsed": false, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 59, "panels": [], "title": "Sort", "type": "row" }, { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-BlYlRd" }, "mappings": [], "max": 9, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [ { "matcher": { "id": "byName", "options": "KlimaFlurEnergy delta" }, "properties": [ { "id": "unit", "value": "watth" }, { "id": "displayName", "value": "Klimaanlage Flur/Schlafzimmer" }, { "id": "max", "value": 9000 } ] }, { "matcher": { "id": "byName", "options": "KlimaWHZ.ENERGY_Total delta" }, "properties": [ { "id": "displayName", "value": "Klimaanlage Wohnzimmer" } ] }, { "matcher": { "id": "byName", "options": "Kühlschrank.ENERGY_Total delta" }, "properties": [ { "id": "displayName", "value": "Kühlschrank" } ] }, { "matcher": { "id": "byName", "options": "MultimediaWHZ.ENERGY_Total delta" }, "properties": [ { "id": "displayName", "value": "Wohnzimmer-TV" } ] }, { "matcher": { "id": "byName", "options": "PC_Arbeitszimmer_Steckdose.ENERGY_Total delta" }, "properties": [ { "id": "displayName", "value": "PC Arbeitszimmer" } ] }, { "matcher": { "id": "byName", "options": "Spülmaschine_Gosund.ENERGY_Total delta" }, "properties": [ { "id": "displayName", "value": "Spülmaschine" } ] }, { "matcher": { "id": "byName", "options": "Stromverbrauch_YT-Studio delta" }, "properties": [ { "id": "displayName", "value": "YT-Studio" } ] }, { "matcher": { "id": "byName", "options": "Trockner_Gosund1.ENERGY_Total delta" }, "properties": [ { "id": "displayName", "value": "Trockner" } ] }, { "matcher": { "id": "byName", "options": "Waschmaschine_Gosund.ENERGY_Total delta" }, "properties": [ { "id": "displayName", "value": "Waschmaschine" } ] } ] }, "gridPos": { "h": 8, "w": 11, "x": 0, "y": 1 }, "hideTimeOverride": false, "id": 51, "options": { "displayMode": "gradient", "minVizHeight": 10, "minVizWidth": 0, "orientation": "horizontal", "reduceOptions": { "calcs": [ "last" ], "fields": "/^_value$/", "values": true }, "showUnfilled": true }, "pluginVersion": "9.1.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "query": "data = from(bucket: \"iobroker\") \r\n|> range(start: -7d) \r\n|> filter(fn: (r) \r\n => r[\"_measurement\"] == \"Spülmaschine_Gosund.ENERGY_Total\"\r\n or r[\"_measurement\"] == \"MultimediaWHZ.ENERGY_Total\"\r\n or r[\"_measurement\"] == \"Waschmaschine_Gosund.ENERGY_Total\"\r\n or r[\"_measurement\"] == \"Kühlschrank.ENERGY_Total\"\r\n or r[\"_measurement\"] == \"KlimaWHZ.ENERGY_Total\"\r\n //or r[\"_measurement\"] == \"KlimaFlurEnergy\"\r\n or r[\"_measurement\"] == \"PC_Arbeitszimmer_Steckdose.ENERGY_Total\"\r\n or r[\"_measurement\"] == \"Stromverbrauch_YT-Studio\"\r\n or r[\"_measurement\"] == \"Trockner_Gosund1.ENERGY_Total\")\r\n|> filter(fn: (r) => r[\"_field\"] == \"value\")\r\nmin = data \r\n|> min() \r\n|> set(key: \"_field\", value: \"delta\")\r\nmax = data \r\n|> max() \r\n|> set(key: \"_field\", value: \"delta\")\r\nunion(tables: [min, max])\r\n|> difference()\r\n|> group()\r\n|> top(n: 5, columns: [\"_value\"])\r\n|> drop(columns:[\"_start\", \"_stop\",\"_field\"])", "refId": "A" } ], "title": "Stromverbrauch letzte 7 Tage (Bar gauge)", "transformations": [], "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-YlBl" }, "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 8, "w": 11, "x": 11, "y": 1 }, "hideTimeOverride": false, "id": 52, "options": { "displayMode": "lcd", "minVizHeight": 10, "minVizWidth": 0, "orientation": "horizontal", "reduceOptions": { "calcs": [ "last" ], "fields": "/^_value$/", "values": true }, "showUnfilled": true }, "pluginVersion": "9.1.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "query": "from(bucket: \"iobroker\") \r\n|> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n|> filter(fn: (r) \r\n => r[\"_measurement\"] == \"Spülmaschine_Gosund.ENERGY_Power\"\r\n or r[\"_measurement\"] == \"MultimediaWHZ.ENERGY_Power\"\r\n or r[\"_measurement\"] == \"Waschmaschine_Gosund.ENERGY_Power\"\r\n or r[\"_measurement\"] == \"Kühlschrank.ENERGY_Power\"\r\n or r[\"_measurement\"] == \"KlimaWHZ.ENERGY_Power\"\r\n //or r[\"_measurement\"] == \"KlimaFlurEnergy\"\r\n or r[\"_measurement\"] == \"PC_Arbeitszimmer_Steckdose.ENERGY_Power\"\r\n or r[\"_measurement\"] == \"Stromverbrauch_YT-Studio\"\r\n or r[\"_measurement\"] == \"Trockner_Gosund1.ENERGY_Power\")\r\n|> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n|> last()\r\n|> group()\r\n|> top(n:7, columns: [\"_value\"])\r\n|> drop(columns:[\"_start\", \"_stop\",\"_field\"])\r\n\r\n\r\n\r\n\r\n\r\n ", "refId": "A" } ], "title": "Aktueller Stromverbrauch (Bar gauge)", "transformations": [], "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-BlPu" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisGridShow": true, "axisLabel": "", "axisPlacement": "auto", "axisWidth": 1, "fillOpacity": 51, "gradientMode": "scheme", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineWidth": 1, "scaleDistribution": { "type": "linear" } }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 6, "w": 22, "x": 0, "y": 9 }, "hideTimeOverride": false, "id": 56, "options": { "barRadius": 0.05, "barWidth": 0.4, "groupWidth": 0.7, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": false }, "orientation": "vertical", "showValue": "always", "stacking": "none", "text": {}, "tooltip": { "mode": "single", "sort": "none" }, "xField": "_measurement", "xTickLabelRotation": 0, "xTickLabelSpacing": 0 }, "pluginVersion": "9.1.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "query": "from(bucket: \"iobroker\") \r\n|> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n|> filter(fn: (r) => r[\"_measurement\"] =~ /.ENERGY_Power+/)\r\n|> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n|> last()\r\n|> group(columns: [\"_measurement\"])\r\n|> last()\r\n|> filter(fn: (r) => r._value >= 0)\r\n|> group()\r\n|> top(n:7)\r\n|> sort(desc: true)\r\n", "refId": "A" } ], "title": "Top 7 aktueller Stromverbrauch (Bar chart)", "transformations": [], "type": "barchart" }, { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-RdYlGr" }, "mappings": [ { "options": { "pattern": "(Trockner.*)", "result": { "index": 0, "text": "Trockner" } }, "type": "regex" }, { "options": { "pattern": "(.*maWHZ.*)", "result": { "index": 1, "text": "KlimaWhz" } }, "type": "regex" }, { "options": { "pattern": "(.*Arbeitszim.*)", "result": { "index": 2, "text": "PC Arbeitszimmer" } }, "type": "regex" }, { "options": { "pattern": "(Wasch.*)", "result": { "index": 3, "text": "Waschmaschine" } }, "type": "regex" }, { "options": { "pattern": "(Kühlschrank.*)", "result": { "index": 4, "text": "Kühlschrank" } }, "type": "regex" }, { "options": { "pattern": "(Multime.*)", "result": { "index": 5, "text": "Multimedia Whz" } }, "type": "regex" }, { "options": { "pattern": "(.*Proxmox.*)", "result": { "index": 6, "text": "Proxmox Server" } }, "type": "regex" } ], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 7, "w": 22, "x": 0, "y": 15 }, "hideTimeOverride": false, "id": 57, "options": { "displayMode": "gradient", "minVizHeight": 10, "minVizWidth": 0, "orientation": "vertical", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^_value$/", "values": true }, "showUnfilled": true }, "pluginVersion": "9.1.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "query": "from(bucket: \"iobroker\") \r\n|> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n|> filter(fn: (r) => r[\"_measurement\"] =~ /.ENERGY_Power+/)\r\n|> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n|> last()\r\n|> group(columns: [\"_measurement\"])\r\n|> last()\r\n|> filter(fn: (r) => r._value >= 0)\r\n|> group()\r\n|> top(n:3)\r\n|> sort(desc: true)\r\n|> drop(columns:[\"_start\", \"_stop\",\"_field\"])\r\n", "refId": "A" } ], "title": "Top 3 aktueller Stromverbrauch (Bar gauge)", "transformations": [], "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-BlYlRd" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisGridShow": true, "axisLabel": "", "axisPlacement": "auto", "axisWidth": 1, "fillOpacity": 62, "gradientMode": "scheme", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineWidth": 1, "scaleDistribution": { "type": "linear" } }, "decimals": 2, "mappings": [], "max": 11, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 8, "w": 9, "x": 0, "y": 22 }, "hideTimeOverride": false, "id": 49, "options": { "barRadius": 0.15, "barWidth": 0.52, "groupWidth": 0.7, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": false }, "orientation": "horizontal", "showValue": "always", "stacking": "none", "text": {}, "tooltip": { "mode": "single", "sort": "none" }, "xField": "_measurement", "xTickLabelRotation": 0, "xTickLabelSpacing": 0 }, "pluginVersion": "9.1.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "query": "from(bucket: \"iobroker\") \r\n|> range(start: -7d) \r\n|> filter(fn: (r) => r[\"_measurement\"] =~ /.ENERGY_Total+/)\r\n|> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n|> difference()\r\n|> group(columns: [\"_measurement\"])\r\n|> sum()\r\n|> filter(fn: (r) => r._value >= 0)\r\n|> group()\r\n|> top(n:20)\r\n|> sort(desc: true)\r\n", "refId": "A" } ], "title": "Stromverbrauch letzte 7 Tage (Bar chart)", "transformations": [], "type": "barchart" }, { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-BlYlRd" }, "mappings": [ { "options": { "pattern": "(Trockner.*)", "result": { "index": 0, "text": "Trockner" } }, "type": "regex" }, { "options": { "pattern": "(.*maWHZ.*)", "result": { "index": 1, "text": "KlimaWhz" } }, "type": "regex" }, { "options": { "pattern": "(.*Arbeitszim.*)", "result": { "index": 2, "text": "PC Arbeitszimmer" } }, "type": "regex" }, { "options": { "pattern": "(Wasch.*)", "result": { "index": 3, "text": "Waschmaschine" } }, "type": "regex" }, { "options": { "pattern": "(Kühlschrank.*)", "result": { "index": 4, "text": "Kühlschrank" } }, "type": "regex" }, { "options": { "pattern": "(Multime.*)", "result": { "index": 5, "text": "Multimedia Whz" } }, "type": "regex" }, { "options": { "pattern": "(.*Proxmox.*)", "result": { "index": 6, "text": "Proxmox Server" } }, "type": "regex" } ], "max": 500, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 8, "w": 6, "x": 9, "y": 22 }, "hideTimeOverride": false, "id": 50, "options": { "displayMode": "gradient", "minVizHeight": 10, "minVizWidth": 0, "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": true }, "showUnfilled": true }, "pluginVersion": "9.1.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "query": "from(bucket: \"iobroker\") \r\n|> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n|> filter(fn: (r) => r[\"_measurement\"] =~ /.ENERGY_Power+/)\r\n|> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n|> last()\r\n|> filter(fn: (r) => r._value >= 0)\r\n|> group()\r\n|> top(n:5)\r\n|> sort(desc: true)\r\n|> drop(columns:[\"_start\", \"_stop\",\"_field\"])\r\n", "refId": "A" } ], "title": "Top 5 aktueller Stromverbrauch (Bar gauge)", "transformations": [], "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "fieldConfig": { "defaults": { "color": { "mode": "continuous-BlYlRd" }, "mappings": [ { "options": { "pattern": "(Trockner.*)", "result": { "index": 0, "text": "Trockner" } }, "type": "regex" }, { "options": { "pattern": "(.*maWHZ.*)", "result": { "index": 1, "text": "KlimaWhz" } }, "type": "regex" }, { "options": { "pattern": "(.*Arbeitszim.*)", "result": { "index": 2, "text": "PC Arbeitszimmer" } }, "type": "regex" }, { "options": { "pattern": "(Wasch.*)", "result": { "index": 3, "text": "Waschmaschine" } }, "type": "regex" }, { "options": { "pattern": "(Kühlschrank.*)", "result": { "index": 4, "text": "Kühlschrank" } }, "type": "regex" }, { "options": { "pattern": "(Multime.*)", "result": { "index": 5, "text": "Multimedia Whz" } }, "type": "regex" }, { "options": { "pattern": "(.*Proxmox.*)", "result": { "index": 6, "text": "Proxmox Server" } }, "type": "regex" } ], "max": 500, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 8, "w": 7, "x": 15, "y": 22 }, "hideTimeOverride": false, "id": 62, "options": { "displayMode": "gradient", "minVizHeight": 10, "minVizWidth": 0, "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": true }, "showUnfilled": true }, "pluginVersion": "9.1.0", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_IOBROKER-DB}" }, "query": "from(bucket: \"iobroker\") \r\n|> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n|> filter(fn: (r) => r[\"_measurement\"] =~ /.ENERGY_Power+/)\r\n|> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n|> last()\r\n|> filter(fn: (r) => r._value >= 0)\r\n|> group()\r\n|> top(n:3, columns: [\"_value\"])\r\n|> drop(columns:[\"_start\", \"_stop\",\"_field\"])\r\n", "refId": "A" } ], "title": "Top 3 aktueller Stromverbrauch (Bar gauge)", "transformations": [], "type": "bargauge" } ], "refresh": false, "schemaVersion": 37, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "2022-12-15T19:48:13.309Z", "to": "2022-12-17T19:48:13.309Z" }, "timepicker": {}, "timezone": "", "title": "SortDemo", "uid": "7P21Z001V1", "version": 2, "weekStart": "" }