commit b2b5120e80b112dcf3f5b52e2f602e345445f1c8
parent 588507afe2ac85e3a022343addb6efbbdaae4994
Author: Leah (ctucx) <leah@ctu.cx>
Date: Sat, 23 Oct 2021 23:15:43 +0200
parent 588507afe2ac85e3a022343addb6efbbdaae4994
Author: Leah (ctucx) <leah@ctu.cx>
Date: Sat, 23 Oct 2021 23:15:43 +0200
grafana: update smarthome-dashboard
1 file changed, 87 insertions(+), 407 deletions(-)
M
|
494
++++++++++++++-----------------------------------------------------------------
diff --git a/config-files/osterei/grafana/dashboards/SmartHome.json b/config-files/osterei/grafana/dashboards/SmartHome.json @@ -15,14 +15,12 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 2, "links": [], "panels": [ { "datasource": "InfluxDB (Sensors)", "fieldConfig": { "defaults": { - "custom": {}, "decimals": 1, "mappings": [], "max": 30, @@ -49,7 +47,7 @@ "overrides": [] }, "gridPos": { - "h": 4, + "h": 6, "w": 3, "x": 0, "y": 0 @@ -65,14 +63,15 @@ "values": false }, "showThresholdLabels": false, - "showThresholdMarkers": true + "showThresholdMarkers": true, + "text": {} }, "pluginVersion": "", "targets": [ { - "alias": "Bad", + "alias": "L. Zimmer", "groupBy": [], - "measurement": "lacrosse-bad", + "measurement": "lacrosse-l1", "orderByTime": "ASC", "policy": "autogen", "query": "SELECT mean(\"value\") FROM \"sensors\".\"measurement\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", @@ -104,7 +103,6 @@ "description": "", "fieldConfig": { "defaults": { - "custom": {}, "decimals": 2, "mappings": [], "max": 260, @@ -135,7 +133,7 @@ "overrides": [] }, "gridPos": { - "h": 9, + "h": 6, "w": 3, "x": 3, "y": 0 @@ -151,36 +149,13 @@ "values": false }, "showThresholdLabels": false, - "showThresholdMarkers": true + "showThresholdMarkers": true, + "text": {} }, "pluginVersion": "", "targets": [ { - "alias": "Sonstiges", - "groupBy": [], - "measurement": "modbus-50", - "orderByTime": "ASC", - "policy": "default", - "refId": "A", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "voltage" - ], - "type": "field" - }, - { - "params": [], - "type": "last" - } - ] - ], - "tags": [] - }, - { - "alias": "Küche", + "alias": "L. Zimmer", "groupBy": [], "measurement": "modbus-60", "orderByTime": "ASC", @@ -214,7 +189,6 @@ "datasource": "InfluxDB (Powermeters)", "fieldConfig": { "defaults": { - "custom": {}, "decimals": 2, "mappings": [], "max": 51, @@ -237,7 +211,7 @@ "overrides": [] }, "gridPos": { - "h": 9, + "h": 6, "w": 3, "x": 6, "y": 0 @@ -252,37 +226,13 @@ "values": false }, "showThresholdLabels": false, - "showThresholdMarkers": true + "showThresholdMarkers": true, + "text": {} }, "pluginVersion": "", "targets": [ { - "alias": "Sonstiges", - "groupBy": [], - "measurement": "modbus-50", - "orderByTime": "ASC", - "policy": "default", - "queryType": "randomWalk", - "refId": "A", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "frequency" - ], - "type": "field" - }, - { - "params": [], - "type": "last" - } - ] - ], - "tags": [] - }, - { - "alias": "Küche", + "alias": "L. Zimmer", "groupBy": [], "measurement": "modbus-60", "orderByTime": "ASC", @@ -317,7 +267,6 @@ "datasource": "InfluxDB (Powermeters)", "fieldConfig": { "defaults": { - "custom": {}, "decimals": 2, "mappings": [], "max": 16, @@ -339,7 +288,7 @@ "overrides": [] }, "gridPos": { - "h": 9, + "h": 6, "w": 3, "x": 9, "y": 0 @@ -354,37 +303,13 @@ "values": false }, "showThresholdLabels": false, - "showThresholdMarkers": true + "showThresholdMarkers": true, + "text": {} }, "pluginVersion": "", "targets": [ { - "alias": "Sonstiges", - "groupBy": [], - "measurement": "modbus-50", - "orderByTime": "ASC", - "policy": "default", - "queryType": "randomWalk", - "refId": "A", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "current" - ], - "type": "field" - }, - { - "params": [], - "type": "last" - } - ] - ], - "tags": [] - }, - { - "alias": "Küche", + "alias": "L. Zimmer", "groupBy": [], "measurement": "modbus-60", "orderByTime": "ASC", @@ -419,7 +344,6 @@ "datasource": "InfluxDB (Powermeters)", "fieldConfig": { "defaults": { - "custom": {}, "decimals": 3, "mappings": [], "max": 1, @@ -442,7 +366,7 @@ "overrides": [] }, "gridPos": { - "h": 9, + "h": 6, "w": 3, "x": 12, "y": 0 @@ -458,36 +382,13 @@ "values": false }, "showThresholdLabels": false, - "showThresholdMarkers": true + "showThresholdMarkers": true, + "text": {} }, "pluginVersion": "", "targets": [ { - "alias": "Sonstiges", - "groupBy": [], - "measurement": "modbus-50", - "orderByTime": "ASC", - "policy": "default", - "refId": "A", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "cosphi" - ], - "type": "field" - }, - { - "params": [], - "type": "last" - } - ] - ], - "tags": [] - }, - { - "alias": "Küche", + "alias": "L. Zimmer", "groupBy": [], "measurement": "modbus-60", "orderByTime": "ASC", @@ -521,7 +422,6 @@ "datasource": "InfluxDB (Powermeters)", "fieldConfig": { "defaults": { - "custom": {}, "decimals": 2, "mappings": [], "max": 3600, @@ -548,7 +448,7 @@ "overrides": [] }, "gridPos": { - "h": 9, + "h": 6, "w": 3, "x": 15, "y": 0 @@ -564,37 +464,13 @@ "values": false }, "showThresholdLabels": false, - "showThresholdMarkers": true + "showThresholdMarkers": true, + "text": {} }, "pluginVersion": "", "targets": [ { - "alias": "Sonstiges", - "groupBy": [], - "measurement": "modbus-50", - "orderByTime": "ASC", - "policy": "default", - "queryType": "randomWalk", - "refId": "A", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "power" - ], - "type": "field" - }, - { - "params": [], - "type": "last" - } - ] - ], - "tags": [] - }, - { - "alias": "Küche", + "alias": "L. Zimmer", "groupBy": [], "measurement": "modbus-60", "orderByTime": "ASC", @@ -629,7 +505,6 @@ "datasource": "InfluxDB (Powermeters)", "fieldConfig": { "defaults": { - "custom": {}, "decimals": 1, "mappings": [], "thresholds": { @@ -646,7 +521,7 @@ "overrides": [] }, "gridPos": { - "h": 9, + "h": 6, "w": 3, "x": 18, "y": 0 @@ -664,37 +539,13 @@ "fields": "", "values": false }, + "text": {}, "textMode": "value_and_name" }, "pluginVersion": "", "targets": [ { - "alias": "Sonstiges", - "groupBy": [], - "measurement": "modbus-50", - "orderByTime": "ASC", - "policy": "default", - "queryType": "randomWalk", - "refId": "A", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "import" - ], - "type": "field" - }, - { - "params": [], - "type": "last" - } - ] - ], - "tags": [] - }, - { - "alias": "Küche", + "alias": "L. Zimmer", "groupBy": [], "measurement": "modbus-60", "orderByTime": "ASC", @@ -729,7 +580,6 @@ "datasource": "InfluxDB (Sensors)", "fieldConfig": { "defaults": { - "custom": {}, "decimals": 1, "mappings": [], "max": 10, @@ -756,7 +606,7 @@ "overrides": [] }, "gridPos": { - "h": 4, + "h": 6, "w": 3, "x": 21, "y": 0 @@ -771,7 +621,8 @@ "values": false }, "showThresholdLabels": false, - "showThresholdMarkers": true + "showThresholdMarkers": true, + "text": {} }, "pluginVersion": "", "targets": [ @@ -810,175 +661,6 @@ "type": "gauge" }, { - "datasource": "InfluxDB (Sensors)", - "fieldConfig": { - "defaults": { - "custom": {}, - "decimals": 1, - "mappings": [], - "max": 30, - "min": 0, - "thresholds": { - "mode": "absolute", - "steps": [ - { - "color": "red", - "value": null - }, - { - "color": "green", - "value": 9 - }, - { - "color": "red", - "value": 23 - } - ] - }, - "unit": "celsius" - }, - "overrides": [] - }, - "gridPos": { - "h": 5, - "w": 3, - "x": 0, - "y": 4 - }, - "id": 22, - "options": { - "orientation": "auto", - "reduceOptions": { - "calcs": [ - "lastNotNull" - ], - "fields": "", - "values": false - }, - "showThresholdLabels": false, - "showThresholdMarkers": true - }, - "pluginVersion": "", - "targets": [ - { - "alias": "", - "groupBy": [], - "measurement": "lacrosse-raum", - "orderByTime": "ASC", - "policy": "autogen", - "query": "SELECT last(\"temperature\") FROM \"autogen\".\"lacrosse-raum\" WHERE $timeFilter", - "queryType": "randomWalk", - "rawQuery": false, - "refId": "A", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "temperature" - ], - "type": "field" - }, - { - "params": [], - "type": "last" - } - ] - ], - "tags": [] - } - ], - "timeFrom": null, - "timeShift": null, - "title": "Zimmer", - "transparent": true, - "type": "gauge" - }, - { - "datasource": "InfluxDB (Sensors)", - "fieldConfig": { - "defaults": { - "custom": {}, - "decimals": 1, - "mappings": [], - "max": 30, - "min": -8, - "thresholds": { - "mode": "absolute", - "steps": [ - { - "color": "red", - "value": null - }, - { - "color": "green", - "value": 5 - }, - { - "color": "red", - "value": 25 - } - ] - }, - "unit": "celsius" - }, - "overrides": [] - }, - "gridPos": { - "h": 5, - "w": 3, - "x": 21, - "y": 4 - }, - "id": 19, - "options": { - "reduceOptions": { - "calcs": [ - "lastNotNull" - ], - "fields": "", - "values": false - }, - "showThresholdLabels": false, - "showThresholdMarkers": true - }, - "pluginVersion": "", - "targets": [ - { - "alias": "", - "groupBy": [], - "measurement": "lacrosse-draussen", - "orderByTime": "ASC", - "policy": "autogen", - "query": "SELECT mean(\"value\") FROM \"sensors\".\"measurement\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", - "queryType": "randomWalk", - "rawQuery": false, - "refId": "A", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "temperature" - ], - "type": "field" - }, - { - "params": [], - "type": "last" - } - ] - ], - "tags": [] - } - ], - "timeFrom": null, - "timeShift": null, - "title": "Draußen", - "transparent": true, - "type": "gauge" - }, - { "aliasColors": {}, "bars": false, "dashLength": 10, @@ -987,7 +669,6 @@ "description": "", "fieldConfig": { "defaults": { - "custom": {}, "unit": "watt" }, "overrides": [] @@ -995,10 +676,10 @@ "fill": 1, "fillGradient": 0, "gridPos": { - "h": 7, + "h": 8, "w": 12, "x": 0, - "y": 9 + "y": 6 }, "hiddenSeries": false, "id": 2, @@ -1154,7 +835,6 @@ "datasource": "InfluxDB (Powermeters)", "fieldConfig": { "defaults": { - "custom": {}, "unit": "volt" }, "overrides": [] @@ -1162,10 +842,10 @@ "fill": 1, "fillGradient": 0, "gridPos": { - "h": 7, + "h": 8, "w": 12, "x": 12, - "y": 9 + "y": 6 }, "hiddenSeries": false, "id": 24, @@ -1320,7 +1000,6 @@ "datasource": "InfluxDB (Sensors)", "fieldConfig": { "defaults": { - "custom": {}, "unit": "celsius" }, "overrides": [] @@ -1331,7 +1010,7 @@ "h": 8, "w": 12, "x": 0, - "y": 16 + "y": 14 }, "hiddenSeries": false, "id": 26, @@ -1481,7 +1160,7 @@ "tags": [] }, { - "alias": "Zimmer", + "alias": "Zimmer1", "groupBy": [ { "params": [ @@ -1496,7 +1175,7 @@ "type": "fill" } ], - "measurement": "lacrosse-raum", + "measurement": "lacrosse-l1", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"temperature\") FROM \"lacrosse-kuehlschrank\" WHERE $timeFilter GROUP BY time($__interval) fill(linear)", @@ -1519,6 +1198,47 @@ ] ], "tags": [] + }, + { + "alias": "Zimmer2", + "groupBy": [ + { + "params": [ + "$__interval" + ], + "type": "time" + }, + { + "params": [ + "linear" + ], + "type": "fill" + } + ], + "hide": false, + "measurement": "lacrosse-l2", + "orderByTime": "ASC", + "policy": "default", + "query": "SELECT mean(\"temperature\") FROM \"lacrosse-kuehlschrank\" WHERE $timeFilter GROUP BY time($__interval) fill(linear)", + "queryType": "randomWalk", + "rawQuery": false, + "refId": "E", + "resultFormat": "time_series", + "select": [ + [ + { + "params": [ + "temperature" + ], + "type": "field" + }, + { + "params": [], + "type": "mean" + } + ] + ], + "tags": [] } ], "thresholds": [], @@ -1570,7 +1290,6 @@ "datasource": "InfluxDB (Sensors)", "fieldConfig": { "defaults": { - "custom": {}, "unit": "humidity" }, "overrides": [] @@ -1581,7 +1300,7 @@ "h": 8, "w": 12, "x": 12, - "y": 16 + "y": 14 }, "hiddenSeries": false, "id": 27, @@ -1651,47 +1370,7 @@ "tags": [] }, { - "alias": "Draußen", - "groupBy": [ - { - "params": [ - "$__interval" - ], - "type": "time" - }, - { - "params": [ - "linear" - ], - "type": "fill" - } - ], - "measurement": "lacrosse-draussen", - "orderByTime": "ASC", - "policy": "default", - "query": "SELECT mean(\"value\") FROM \"measurement\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", - "queryType": "randomWalk", - "rawQuery": false, - "refId": "B", - "resultFormat": "time_series", - "select": [ - [ - { - "params": [ - "humidity" - ], - "type": "field" - }, - { - "params": [], - "type": "mean" - } - ] - ], - "tags": [] - }, - { - "alias": "Zimmer", + "alias": "L. Zimmer", "groupBy": [ { "params": [ @@ -1706,13 +1385,14 @@ "type": "fill" } ], - "measurement": "lacrosse-raum", + "hide": false, + "measurement": "lacrosse-l1", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"temperature\") FROM \"lacrosse-kuehlschrank\" WHERE $timeFilter GROUP BY time($__interval) fill(linear)", "queryType": "randomWalk", "rawQuery": false, - "refId": "D", + "refId": "C", "resultFormat": "time_series", "select": [ [ @@ -1774,14 +1454,14 @@ } ], "refresh": "5s", - "schemaVersion": 26, + "schemaVersion": 27, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { - "from": "now-6h", + "from": "now-12h", "to": "now" }, "timepicker": { @@ -1801,5 +1481,5 @@ "timezone": "", "title": "SmartHome (Influx)", "uid": "FRDYqjEGz", - "version": 3 + "version": 7 } \ No newline at end of file