Created
March 27, 2018 09:12
-
-
Save Nesousx/3941d33ee6c2282c29fa70e69c54fb1f to your computer and use it in GitHub Desktop.
Nesatmo Grafana Dashboard
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "__inputs": [ | |
| { | |
| "name": "DS_NETATMO", | |
| "label": "netatmo", | |
| "description": "", | |
| "type": "datasource", | |
| "pluginId": "influxdb", | |
| "pluginName": "InfluxDB" | |
| }, | |
| { | |
| "name": "DS_TEST", | |
| "label": "test", | |
| "description": "", | |
| "type": "datasource", | |
| "pluginId": "influxdb", | |
| "pluginName": "InfluxDB" | |
| } | |
| ], | |
| "__requires": [ | |
| { | |
| "type": "grafana", | |
| "id": "grafana", | |
| "name": "Grafana", | |
| "version": "5.0.3" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "graph", | |
| "name": "Graph", | |
| "version": "5.0.0" | |
| }, | |
| { | |
| "type": "datasource", | |
| "id": "influxdb", | |
| "name": "InfluxDB", | |
| "version": "5.0.0" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "singlestat", | |
| "name": "Singlestat", | |
| "version": "5.0.0" | |
| } | |
| ], | |
| "annotations": { | |
| "list": [ | |
| { | |
| "builtIn": 1, | |
| "datasource": "-- Grafana --", | |
| "enable": true, | |
| "hide": true, | |
| "iconColor": "rgba(0, 211, 255, 1)", | |
| "name": "Annotations & Alerts", | |
| "type": "dashboard" | |
| } | |
| ] | |
| }, | |
| "editable": true, | |
| "gnetId": null, | |
| "graphTooltip": 0, | |
| "id": null, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 19, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Quick stats", | |
| "type": "row" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "rgba(52, 85, 234, 0.97)", | |
| "rgba(13, 174, 24, 0.89)", | |
| "rgba(245, 54, 54, 0.9)" | |
| ], | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "format": "pressurembar", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 4, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "id": 17, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": false | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "pressure", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT last(\"value\") FROM \"AbsolutePressure\" WHERE $timeFilter AND \"station_name\" =~ /^$station$/ GROUP BY time($interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": "990,1010,1020", | |
| "title": "Pressure", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#c15c17", | |
| "#508642", | |
| "#58140c" | |
| ], | |
| "datasource": "${DS_NETATMO}", | |
| "decimals": 1, | |
| "editable": true, | |
| "error": false, | |
| "format": "celsius", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 4, | |
| "x": 4, | |
| "y": 1 | |
| }, | |
| "id": 8, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "temperature", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT last(\"value\") FROM \"Temperature\" WHERE \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": "15,25", | |
| "title": "Temperature inside", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "rgba(50, 172, 45, 0.97)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(245, 54, 54, 0.9)" | |
| ], | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "format": "percent", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 4, | |
| "x": 8, | |
| "y": 1 | |
| }, | |
| "id": 32, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "humidity", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"CO2\" WHERE $timeFilter AND \"station_name\" =~ /^$station$/ GROUP BY time($interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": "60,90", | |
| "title": "Humidity inside", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "rgba(50, 172, 45, 0.97)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(245, 54, 54, 0.9)" | |
| ], | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "format": "ppm", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 10, | |
| "w": 4, | |
| "x": 12, | |
| "y": 1 | |
| }, | |
| "id": 2, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "co2", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"CO2\" WHERE $timeFilter AND \"station_name\" =~ /^$station$/ GROUP BY time($interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": "1000,1500", | |
| "title": "Mean CO2 level inside", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#3f6833", | |
| "#cca300", | |
| "#890f02" | |
| ], | |
| "datasource": "${DS_NETATMO}", | |
| "decimals": null, | |
| "editable": true, | |
| "error": false, | |
| "format": "dB", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 10, | |
| "w": 4, | |
| "x": 16, | |
| "y": 1 | |
| }, | |
| "id": 34, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "noise", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": "50,70", | |
| "title": "Inside noise", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#3f6833", | |
| "#cca300", | |
| "#890f02" | |
| ], | |
| "datasource": "${DS_TEST}", | |
| "decimals": 1, | |
| "editable": true, | |
| "error": false, | |
| "format": "percent", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 10, | |
| "w": 4, | |
| "x": 20, | |
| "y": 1 | |
| }, | |
| "id": 30, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [], | |
| "thresholds": "50,80", | |
| "title": "Outdoor battery health", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "rgba(52, 85, 234, 0.97)", | |
| "rgba(13, 174, 24, 0.89)", | |
| "rgba(245, 54, 54, 0.9)" | |
| ], | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "format": "pressurembar", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 4, | |
| "x": 0, | |
| "y": 6 | |
| }, | |
| "id": 31, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": false | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "absolutepressure", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT last(\"value\") FROM \"AbsolutePressure\" WHERE $timeFilter AND \"station_name\" =~ /^$station$/ GROUP BY time($interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": "990,1010,1020", | |
| "title": "Absolute pressure", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#052b51", | |
| "#614d93", | |
| "#511749" | |
| ], | |
| "datasource": "${DS_NETATMO}", | |
| "decimals": 1, | |
| "editable": true, | |
| "error": false, | |
| "format": "celsius", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 4, | |
| "x": 4, | |
| "y": 6 | |
| }, | |
| "id": 28, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "temperature", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT last(\"value\") FROM \"Temperature\" WHERE \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "outdoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": "5,20", | |
| "title": "Temperature outside", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "rgba(50, 172, 45, 0.97)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(245, 54, 54, 0.9)" | |
| ], | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "format": "percent", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 4, | |
| "x": 8, | |
| "y": 6 | |
| }, | |
| "id": 33, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "humidity", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"CO2\" WHERE $timeFilter AND \"station_name\" =~ /^$station$/ GROUP BY time($interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "outdoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": "60,90", | |
| "title": "Humidity outside", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 11 | |
| }, | |
| "id": 18, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Temperature", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NETATMO}", | |
| "decimals": null, | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 24, | |
| "x": 0, | |
| "y": 12 | |
| }, | |
| "id": 29, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "Temperature outside - $tag_station_name", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "station_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "temperature", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"Temperature\" WHERE \"module_type\" = 'Outdoor' AND \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval), \"station_name\" fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [ | |
| { | |
| "colorMode": "custom", | |
| "line": true, | |
| "lineColor": "rgba(216, 82, 27, 0.27)", | |
| "op": "gt", | |
| "value": 0 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Temperature inside", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "celsius", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": { | |
| "Temperature outside - ": "#e5ac0e" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 24, | |
| "x": 0, | |
| "y": 19 | |
| }, | |
| "id": 1, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "Temperature outside - $tag_station_name", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "station_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "temperature", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"Temperature\" WHERE \"module_type\" = 'Outdoor' AND \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval), \"station_name\" fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "outdoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [ | |
| { | |
| "colorMode": "custom", | |
| "line": true, | |
| "lineColor": "rgba(216, 82, 27, 0.27)", | |
| "op": "gt", | |
| "value": 0 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Temperature outside", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "celsius", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 26 | |
| }, | |
| "id": 21, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "CO2", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NETATMO}", | |
| "decimals": null, | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 24, | |
| "x": 0, | |
| "y": 27 | |
| }, | |
| "id": 7, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "CO2 - $tag_module_name", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "module_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "co2", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"CO2\" WHERE \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval), \"module_name\" fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [ | |
| { | |
| "colorMode": "custom", | |
| "fill": true, | |
| "fillColor": "rgba(216, 200, 27, 0.27)", | |
| "op": "gt", | |
| "value": 1000 | |
| }, | |
| { | |
| "colorMode": "custom", | |
| "fill": true, | |
| "fillColor": "rgba(234, 112, 112, 0.22)", | |
| "op": "gt", | |
| "value": 1500 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "CO2 level inside", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "ppm", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 34 | |
| }, | |
| "id": 23, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Pressure", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 24, | |
| "x": 0, | |
| "y": 35 | |
| }, | |
| "id": 4, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "Pressure - $tag_module_name", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "module_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "pressure", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"Pressure\" WHERE \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval), \"module_name\" fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| }, | |
| { | |
| "alias": "Absolute Pressure - $tag_module_name", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "module_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "absolutepressure", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"Pressure\" WHERE \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval), \"module_name\" fill(null)", | |
| "rawQuery": false, | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Pressure", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "pressurembar", | |
| "logBase": 1, | |
| "max": 1040, | |
| "min": 960, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 42 | |
| }, | |
| "id": 24, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Humidity", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 24, | |
| "x": 0, | |
| "y": 43 | |
| }, | |
| "id": 3, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "Humidity - indoors", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "module_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "humidity", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"Humidity\" WHERE \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval), \"module_name\" fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| }, | |
| { | |
| "alias": "Humidity - outdoors", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "module_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "humidity", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"Humidity\" WHERE \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval), \"module_name\" fill(null)", | |
| "rawQuery": false, | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "outdoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Humidity levels", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "percent", | |
| "logBase": 1, | |
| "max": 100, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 50 | |
| }, | |
| "id": 25, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Noise", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NETATMO}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 24, | |
| "x": 0, | |
| "y": 51 | |
| }, | |
| "id": 5, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "Noise level - $tag_module_name", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "module_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "noise", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"Noise\" WHERE \"station_name\" =~ /^$station$/ AND $timeFilter GROUP BY time($interval), \"module_name\" fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "station", | |
| "operator": "=", | |
| "value": "nesoweath" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "sensor", | |
| "operator": "=", | |
| "value": "indoor" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [ | |
| { | |
| "colorMode": "warning", | |
| "fill": true, | |
| "line": true, | |
| "op": "gt", | |
| "value": 50 | |
| }, | |
| { | |
| "colorMode": "critical", | |
| "fill": true, | |
| "line": true, | |
| "op": "gt", | |
| "value": 70 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Noise level inside", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "dB", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| } | |
| ], | |
| "refresh": "5m", | |
| "schemaVersion": 16, | |
| "style": "dark", | |
| "tags": [], | |
| "templating": { | |
| "list": [] | |
| }, | |
| "time": { | |
| "from": "now-24h", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "now": true, | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ], | |
| "time_options": [ | |
| "5m", | |
| "15m", | |
| "1h", | |
| "6h", | |
| "12h", | |
| "24h", | |
| "2d", | |
| "7d", | |
| "30d" | |
| ] | |
| }, | |
| "timezone": "browser", | |
| "title": "NesoWeath", | |
| "uid": "fcjuO16kz", | |
| "version": 36 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment