ctucx.git: nixfiles

machines/trabbi/grafana: update SmartHome dashboard

diff --git a/machines/trabbi/grafana/dashboards/SmartHome.json b/machines/trabbi/grafana/dashboards/SmartHome.json
@@ -79,7 +79,7 @@
         "showThresholdMarkers": true,
         "text": {}
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -154,7 +154,7 @@
         "showThresholdMarkers": true,
         "text": {}
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -217,7 +217,7 @@
         "showThresholdMarkers": true,
         "text": {}
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -276,7 +276,7 @@
         "text": {},
         "textMode": "value"
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -344,7 +344,7 @@
         "showThresholdMarkers": true,
         "text": {}
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -407,7 +407,7 @@
         "showThresholdMarkers": true,
         "text": {}
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -474,7 +474,7 @@
         "showThresholdMarkers": true,
         "text": {}
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -852,7 +852,7 @@
             "type": "influxdb",
             "uid": "PE2A2C1E083866E29"
           },
-          "query": "import \"strings\"\n\nfrom(bucket: \"mqttData\")\n  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)\n  |> filter(fn: (r) => (r._measurement == \"mqtt_consumer\" and r._field == \"temperature\"))\n  |> drop(columns: [\"host\", \"_field\"])\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: true)\n  |> map(fn: (r) => ({r with topic: strings.trimPrefix(v: r.topic, prefix: \"zigbee2mqtt/\")}))\n  |> yield()",
+          "query": "import \"strings\"\n\nfrom(bucket: \"mqttData\")\n  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)\n  |> filter(fn: (r) => strings.hasPrefix(v: r.topic, prefix: \"zigbee2mqtt\"))\n  |> filter(fn: (r) => (r._measurement == \"mqtt_consumer\" and r._field == \"temperature\"))\n  |> drop(columns: [\"host\", \"_field\"])\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: true)\n  |> map(fn: (r) => ({r with topic: strings.trimPrefix(v: r.topic, prefix: \"zigbee2mqtt/\")}))\n  |> yield()",
           "refId": "A"
         }
       ],

@@ -908,7 +908,7 @@
         },
         "showUnfilled": true
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -1003,7 +1003,7 @@
             "type": "influxdb",
             "uid": "PE2A2C1E083866E29"
           },
-          "query": "import \"strings\"\n\nfrom(bucket: \"mqttData\")\n  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)\n  |> filter(fn: (r) => (r._measurement == \"mqtt_consumer\" and r._field == \"humidity\"))\n  |> drop(columns: [\"host\", \"_field\"])\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: true)\n  |> map(fn: (r) => ({r with topic: strings.trimPrefix(v: r.topic, prefix: \"zigbee2mqtt/\")}))\n  |> yield()",
+          "query": "import \"strings\"\n\nfrom(bucket: \"mqttData\")\n  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)\n  |> filter(fn: (r) => strings.hasPrefix(v: r.topic, prefix: \"zigbee2mqtt\"))\n  |> filter(fn: (r) => (r._measurement == \"mqtt_consumer\" and r._field == \"humidity\"))\n  |> drop(columns: [\"host\", \"_field\"])\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: true)\n  |> map(fn: (r) => ({r with topic: strings.trimPrefix(v: r.topic, prefix: \"zigbee2mqtt/\")}))\n  |> yield()",
           "refId": "A"
         }
       ],

@@ -1020,7 +1020,9 @@
         "defaults": {
           "custom": {
             "align": "auto",
-            "displayMode": "auto",
+            "cellOptions": {
+              "type": "auto"
+            },
             "inspect": false
           },
           "mappings": [],

@@ -1059,6 +1061,7 @@
       "id": 34,
       "options": {
         "footer": {
+          "countRows": false,
           "fields": "",
           "reducer": [
             "sum"

@@ -1067,7 +1070,7 @@
         },
         "showHeader": true
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -1117,7 +1120,9 @@
         "defaults": {
           "custom": {
             "align": "auto",
-            "displayMode": "auto",
+            "cellOptions": {
+              "type": "auto"
+            },
             "inspect": false
           },
           "mappings": [],

@@ -1156,6 +1161,7 @@
       "id": 32,
       "options": {
         "footer": {
+          "countRows": false,
           "fields": "",
           "reducer": [
             "sum"

@@ -1164,7 +1170,7 @@
         },
         "showHeader": true
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -1213,7 +1219,9 @@
         "defaults": {
           "custom": {
             "align": "auto",
-            "displayMode": "auto",
+            "cellOptions": {
+              "type": "auto"
+            },
             "inspect": false
           },
           "mappings": [],

@@ -1252,6 +1260,7 @@
       "id": 33,
       "options": {
         "footer": {
+          "countRows": false,
           "fields": "",
           "reducer": [
             "sum"

@@ -1260,7 +1269,7 @@
         },
         "showHeader": true
       },
-      "pluginVersion": "9.3.1",
+      "pluginVersion": "9.4.3",
       "targets": [
         {
           "datasource": {

@@ -1301,8 +1310,9 @@
       "type": "table"
     }
   ],
-  "refresh": "1m",
-  "schemaVersion": 37,
+  "refresh": "30s",
+  "revision": 1,
+  "schemaVersion": 38,
   "style": "dark",
   "tags": [],
   "templating": {