====== Grafana Example Layout ====== {{:homeautomatisation:grafana:grafana_example.jpg?400|}} { "annotations": { "list": [ { "builtIn": 1, "datasource": "-- 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": 3, "links": [], "liveNow": false, "panels": [ { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 500, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 400 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 4, "w": 2, "x": 0, "y": 0 }, "id": 14, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true, "text": {} }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start:0)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"0_userdata.0.Wattzähler.Arbeitszimmer.Watt_Aktuell\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> fill(usePrevious: true)\r\n |> last()", "refId": "A" } ], "title": "Arbeitszimmer", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 4, "w": 10, "x": 2, "y": 0 }, "id": 12, "options": { "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"0_userdata.0.Wattzähler.Arbeitszimmer.Watt_Aktuell\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "type": "timeseries" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "unit": "watth" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 12, "y": 0 }, "id": 19, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"0_userdata.0.Wattzähler.Arbeitszimmer.Watt_Aktuell\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> integral(unit:1h)", "refId": "A" } ], "title": "Wh", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 30, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 10 }, { "color": "dark-green", "value": 20 }, { "color": "red", "value": 30 } ] }, "unit": "celsius" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 15, "y": 0 }, "id": 10, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0007e240d6.temperature\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Temp", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 30 }, { "color": "dark-green", "value": 40 }, { "color": "red", "value": 75 } ] }, "unit": "humidity" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 18, "y": 0 }, "id": 21, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0007e240d6.humidity\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Feucht", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 1500, "min": 700, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 700 }, { "color": "dark-green", "value": 1000 }, { "color": "red", "value": 1400 } ] }, "unit": "pressurehpa" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 21, "y": 0 }, "id": 20, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0007e240d6.pressure\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Luft", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 4, "w": 2, "x": 0, "y": 4 }, "id": 8, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start:0)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#F0590C#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> fill(usePrevious: true)\r\n |> last()", "refId": "A" } ], "title": "IntelNuc", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 4, "w": 10, "x": 2, "y": 4 }, "id": 15, "options": { "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#F0590C#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "type": "timeseries" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "unit": "watth" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 12, "y": 4 }, "id": 22, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#F0590C#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> integral(unit:1h)", "refId": "A" } ], "title": "Wh", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 30, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 10 }, { "color": "dark-green", "value": 20 }, { "color": "red", "value": 30 } ] }, "unit": "celsius" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 15, "y": 4 }, "id": 26, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0003cbc5f1.temperature\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Bad", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 30 }, { "color": "dark-green", "value": 40 }, { "color": "red", "value": 75 } ] }, "unit": "humidity" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 18, "y": 4 }, "id": 27, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0003cbc5f1.humidity\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Bad", "type": "gauge" }, { "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 600, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 500 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 4, "w": 2, "x": 0, "y": 8 }, "id": 4, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start:0)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#BC4F80#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> fill(usePrevious: true)\r\n |> last()", "refId": "A" } ], "title": "Fernseher", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 10, "x": 2, "y": 8 }, "id": 16, "options": { "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#BC4F80#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "type": "timeseries" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "unit": "watth" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 12, "y": 8 }, "id": 23, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#BC4F80#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> integral(unit:1h)", "refId": "A" } ], "title": "Wh", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 30, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 10 }, { "color": "dark-green", "value": 20 }, { "color": "red", "value": 30 } ] }, "unit": "celsius" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 15, "y": 8 }, "id": 28, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0003cf07b4.temperature\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Marie", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 30 }, { "color": "dark-green", "value": 40 }, { "color": "red", "value": 75 } ] }, "unit": "humidity" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 18, "y": 8 }, "id": 29, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0003cf07b4.humidity\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Marie", "type": "gauge" }, { "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 2250, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 2000 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 4, "w": 2, "x": 0, "y": 12 }, "id": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start:0)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#E3ED07#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> fill(usePrevious: true)\r\n |> last()", "refId": "A" } ], "title": "Waschmaschine", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 10, "x": 2, "y": 12 }, "id": 17, "options": { "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#E3ED07#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "type": "timeseries" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "unit": "watth" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 12, "y": 12 }, "id": 24, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#E3ED07#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> integral(unit:1h)", "refId": "A" } ], "title": "Wh", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 30, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 10 }, { "color": "dark-green", "value": 20 }, { "color": "red", "value": 30 } ] }, "unit": "celsius" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 15, "y": 12 }, "id": 30, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0004102b56.temperature\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Schlaf", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 30 }, { "color": "dark-green", "value": 40 }, { "color": "red", "value": 75 } ] }, "unit": "humidity" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 18, "y": 12 }, "id": 31, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d0004102b56.humidity\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Schlaf", "type": "gauge" }, { "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 2000, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 2000 } ] }, "unit": "watt" }, "overrides": [] }, "gridPos": { "h": 4, "w": 2, "x": 0, "y": 16 }, "id": 2, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start:0)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#1C032F#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> fill(usePrevious: true)\r\n |> last()", "refId": "A" } ], "title": "Geschirrspühler", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 10, "x": 2, "y": 16 }, "id": 18, "options": { "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#1C032F#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "type": "timeseries" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "unit": "watth" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 12, "y": 16 }, "id": 25, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"shelly.0.SHPLG-S#1C032F#1.Relay0.Power\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> integral(unit:1h)", "refId": "A" } ], "title": "Wh", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 30, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 10 }, { "color": "dark-green", "value": 20 }, { "color": "red", "value": 30 } ] }, "unit": "celsius" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 15, "y": 16 }, "id": 32, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d000445963e.temperature\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Wohnzi", "type": "gauge" }, { "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "blue", "value": 30 }, { "color": "dark-green", "value": 40 }, { "color": "red", "value": 75 } ] }, "unit": "humidity" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 18, "y": 16 }, "id": 33, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "8.4.1", "targets": [ { "datasource": { "type": "influxdb", "uid": "rV0qw1B7k" }, "query": "from(bucket: \"iobroker\")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"zigbee.0.00158d000445963e.humidity\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\r\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\r\n |> yield(name: \"mean\")", "refId": "A" } ], "title": "Wohnzi", "type": "gauge" } ], "refresh": false, "schemaVersion": 35, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "now-24h", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Fancy", "uid": "t7sv0CY7k", "version": 23, "weekStart": "" }