Last active
March 7, 2021 11:52
-
-
Save ivanahuckova/0ac0f560fc69e5fa1b103c36f4e7060b to your computer and use it in GitHub Desktop.
This file contains hidden or 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
| { | |
| "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": 1, | |
| "id": 11, | |
| "iteration": 1612022199011, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Avocado Metrics", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 10, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 48, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"humidity\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> aggregateWindow(every: $aggregation, fn: mean)\n |> yield(name: \"value\")", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"temperature\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> aggregateWindow(every: $aggregation, fn: mean)\n |> yield(name: \"mean\")", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"moisture\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> aggregateWindow(every: $aggregation, fn: mean)\n |> yield(name: \"mean\")", | |
| "refId": "C", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"height\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> aggregateWindow(every: $aggregation, fn: mean)\n |> yield(name: \"mean\")", | |
| "refId": "D", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"index\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> yield(name: \"mean\")", | |
| "refId": "E", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": " 🥑 Master graph", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 10 | |
| }, | |
| "id": 46, | |
| "panels": [ | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 12, | |
| "x": 0, | |
| "y": 11 | |
| }, | |
| "id": 21, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{monitoring_type=\"avocado\"} |= \"status=OK\"", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🥑status = OK", | |
| "type": "logs" | |
| }, | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 12, | |
| "x": 12, | |
| "y": 11 | |
| }, | |
| "id": 28, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{monitoring_type=\"avocado\"} |= \"status=DRY\"", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🥑status = DRY", | |
| "type": "logs" | |
| }, | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 12, | |
| "x": 0, | |
| "y": 16 | |
| }, | |
| "id": 18, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{monitoring_type=\"avocado\"} |= \"status=COLD\"", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🥑status = COLD", | |
| "type": "logs" | |
| }, | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 12, | |
| "x": 12, | |
| "y": 16 | |
| }, | |
| "id": 19, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{monitoring_type=\"avocado\"} |= \"status=HOT\"", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🥑status = HOT", | |
| "type": "logs" | |
| } | |
| ], | |
| "title": "Logs [STATUS]", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 11 | |
| }, | |
| "id": 44, | |
| "panels": [ | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 12, | |
| "x": 0, | |
| "y": 12 | |
| }, | |
| "id": 29, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{monitoring_type=\"avocado\"} | logfmt | light < 150", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🌚light = DARK", | |
| "type": "logs" | |
| }, | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 12, | |
| "x": 12, | |
| "y": 12 | |
| }, | |
| "id": 30, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{monitoring_type=\"avocado\"} | logfmt | light > 150 and light < 1000", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🌤light = NORMAL", | |
| "type": "logs" | |
| }, | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 12, | |
| "x": 0, | |
| "y": 17 | |
| }, | |
| "id": 31, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{monitoring_type=\"avocado\"} | logfmt | light > 1001 and light < 3000", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "☀️light = BRIGHT", | |
| "type": "logs" | |
| }, | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 5, | |
| "w": 12, | |
| "x": 12, | |
| "y": 17 | |
| }, | |
| "id": 34, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{monitoring_type=\"avocado\"} | logfmt | light > 3001 ", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "😎light = VERY BRIGHT", | |
| "type": "logs" | |
| } | |
| ], | |
| "title": "Logs [LIGHT]", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 12 | |
| }, | |
| "id": 36, | |
| "panels": [], | |
| "title": "Table ", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": "Avocado Metrics", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": { | |
| "align": null, | |
| "filterable": false | |
| }, | |
| "displayName": "humidity", | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "percent" | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Time" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "displayName" | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value humidity" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "displayName", | |
| "value": "Humidity" | |
| }, | |
| { | |
| "id": "color", | |
| "value": { | |
| "mode": "continuous-YlBl" | |
| } | |
| }, | |
| { | |
| "id": "custom.displayMode", | |
| "value": "color-background" | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value temperature" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "displayName", | |
| "value": "Temperature" | |
| }, | |
| { | |
| "id": "unit", | |
| "value": "celsius" | |
| }, | |
| { | |
| "id": "decimals", | |
| "value": 2 | |
| }, | |
| { | |
| "id": "color", | |
| "value": { | |
| "mode": "continuous-BlYlRd" | |
| } | |
| }, | |
| { | |
| "id": "custom.displayMode", | |
| "value": "color-background" | |
| }, | |
| { | |
| "id": "min", | |
| "value": 19 | |
| }, | |
| { | |
| "id": "max", | |
| "value": 26 | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value moisture" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "unit", | |
| "value": "none" | |
| }, | |
| { | |
| "id": "displayName", | |
| "value": "Soil moisture" | |
| }, | |
| { | |
| "id": "mappings", | |
| "value": [ | |
| { | |
| "from": "0", | |
| "id": 1, | |
| "text": "💧WET 💧", | |
| "to": "0.8", | |
| "type": 2 | |
| }, | |
| { | |
| "from": "0.8", | |
| "id": 2, | |
| "text": "🏜DRY 🏜", | |
| "to": "1", | |
| "type": 2 | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value height" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "displayName", | |
| "value": "Height" | |
| }, | |
| { | |
| "id": "unit", | |
| "value": "cm" | |
| }, | |
| { | |
| "id": "decimals", | |
| "value": 2 | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value index" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "unit", | |
| "value": "none" | |
| }, | |
| { | |
| "id": "displayName", | |
| "value": "Heat index" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 16, | |
| "w": 24, | |
| "x": 0, | |
| "y": 13 | |
| }, | |
| "id": 26, | |
| "interval": "4m", | |
| "maxDataPoints": 5000, | |
| "options": { | |
| "showHeader": true, | |
| "sortBy": [ | |
| { | |
| "desc": true, | |
| "displayName": "Time" | |
| } | |
| ] | |
| }, | |
| "pluginVersion": "7.3.7", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"humidity\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> yield(name: \"value\")", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"temperature\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> yield(name: \"value\")", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"moisture\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> yield(name: \"value\")", | |
| "refId": "C", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"height\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> yield(name: \"value\")", | |
| "refId": "D", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "from(bucket: \"arduino\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r[\"_measurement\"] == \"index\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> yield(name: \"value\")", | |
| "refId": "E", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🥑 Master table", | |
| "transformations": [ | |
| { | |
| "id": "seriesToColumns", | |
| "options": { | |
| "byField": "Time" | |
| } | |
| } | |
| ], | |
| "type": "table" | |
| }, | |
| { | |
| "datasource": "-- Dashboard --", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": { | |
| "align": null, | |
| "filterable": false | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "mappings", | |
| "value": [ | |
| { | |
| "from": "0", | |
| "id": 1, | |
| "text": "WET ", | |
| "to": "0.8", | |
| "type": 2 | |
| }, | |
| { | |
| "from": "0.8", | |
| "id": 2, | |
| "text": "DRY", | |
| "to": "1", | |
| "type": 2 | |
| } | |
| ] | |
| }, | |
| { | |
| "id": "custom.width", | |
| "value": 103 | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value height (mean)" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "custom.displayMode", | |
| "value": "basic" | |
| }, | |
| { | |
| "id": "unit", | |
| "value": "cm" | |
| }, | |
| { | |
| "id": "decimals", | |
| "value": 2 | |
| }, | |
| { | |
| "id": "color", | |
| "value": { | |
| "fixedColor": "green", | |
| "mode": "fixed" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 12, | |
| "x": 0, | |
| "y": 29 | |
| }, | |
| "id": 6, | |
| "options": { | |
| "showHeader": true, | |
| "sortBy": [] | |
| }, | |
| "pluginVersion": "7.3.7", | |
| "targets": [ | |
| { | |
| "panelId": 26, | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "AVG height by Soil Moisture", | |
| "transformations": [ | |
| { | |
| "id": "seriesToColumns", | |
| "options": {} | |
| }, | |
| { | |
| "id": "groupBy", | |
| "options": { | |
| "fields": { | |
| "Time": { | |
| "aggregations": [], | |
| "operation": null | |
| }, | |
| "value height": { | |
| "aggregations": [ | |
| "mean" | |
| ], | |
| "operation": "aggregate" | |
| }, | |
| "value humidity": { | |
| "aggregations": [], | |
| "operation": null | |
| }, | |
| "value moisture": { | |
| "aggregations": [], | |
| "operation": "groupby" | |
| } | |
| } | |
| } | |
| } | |
| ], | |
| "type": "table" | |
| }, | |
| { | |
| "datasource": "-- Dashboard --", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": { | |
| "align": null, | |
| "filterable": false | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "mappings", | |
| "value": [ | |
| { | |
| "from": "0", | |
| "id": 1, | |
| "text": "WET ", | |
| "to": "0.8", | |
| "type": 2 | |
| }, | |
| { | |
| "from": "0.8", | |
| "id": 2, | |
| "text": "DRY", | |
| "to": "1", | |
| "type": 2 | |
| } | |
| ] | |
| }, | |
| { | |
| "id": "custom.width", | |
| "value": 103 | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value temperature (mean)" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "custom.displayMode", | |
| "value": "basic" | |
| }, | |
| { | |
| "id": "unit", | |
| "value": "celsius" | |
| }, | |
| { | |
| "id": "decimals", | |
| "value": 2 | |
| }, | |
| { | |
| "id": "color", | |
| "value": { | |
| "fixedColor": "orange", | |
| "mode": "fixed" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 12, | |
| "x": 12, | |
| "y": 29 | |
| }, | |
| "id": 5, | |
| "options": { | |
| "showHeader": true, | |
| "sortBy": [] | |
| }, | |
| "pluginVersion": "7.3.7", | |
| "targets": [ | |
| { | |
| "panelId": 26, | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "AVG temperature by Soil Moisture", | |
| "transformations": [ | |
| { | |
| "id": "seriesToColumns", | |
| "options": {} | |
| }, | |
| { | |
| "id": "groupBy", | |
| "options": { | |
| "fields": { | |
| "Time": { | |
| "aggregations": [], | |
| "operation": null | |
| }, | |
| "value humidity": { | |
| "aggregations": [], | |
| "operation": null | |
| }, | |
| "value moisture": { | |
| "aggregations": [], | |
| "operation": "groupby" | |
| }, | |
| "value temperature": { | |
| "aggregations": [ | |
| "mean" | |
| ], | |
| "operation": "aggregate" | |
| } | |
| } | |
| } | |
| } | |
| ], | |
| "type": "table" | |
| }, | |
| { | |
| "datasource": "-- Dashboard --", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": { | |
| "align": null, | |
| "filterable": false | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "mappings", | |
| "value": [ | |
| { | |
| "from": "0", | |
| "id": 1, | |
| "text": "WET ", | |
| "to": "0.8", | |
| "type": 2 | |
| }, | |
| { | |
| "from": "0.8", | |
| "id": 2, | |
| "text": "DRY", | |
| "to": "1", | |
| "type": 2 | |
| } | |
| ] | |
| }, | |
| { | |
| "id": "custom.width", | |
| "value": 103 | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value humidity (mean)" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "custom.displayMode", | |
| "value": "basic" | |
| }, | |
| { | |
| "id": "unit", | |
| "value": "percent" | |
| }, | |
| { | |
| "id": "decimals", | |
| "value": 2 | |
| }, | |
| { | |
| "id": "color", | |
| "value": { | |
| "fixedColor": "blue", | |
| "mode": "fixed" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 12, | |
| "x": 0, | |
| "y": 33 | |
| }, | |
| "id": 4, | |
| "options": { | |
| "showHeader": true, | |
| "sortBy": [] | |
| }, | |
| "pluginVersion": "7.3.7", | |
| "targets": [ | |
| { | |
| "panelId": 26, | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "AVG humidity by Soil Moisture", | |
| "transformations": [ | |
| { | |
| "id": "seriesToColumns", | |
| "options": {} | |
| }, | |
| { | |
| "id": "groupBy", | |
| "options": { | |
| "fields": { | |
| "Time": { | |
| "aggregations": [], | |
| "operation": null | |
| }, | |
| "value humidity": { | |
| "aggregations": [ | |
| "mean" | |
| ], | |
| "operation": "aggregate" | |
| }, | |
| "value moisture": { | |
| "aggregations": [], | |
| "operation": "groupby" | |
| } | |
| } | |
| } | |
| } | |
| ], | |
| "type": "table" | |
| }, | |
| { | |
| "datasource": "-- Dashboard --", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": { | |
| "align": null, | |
| "filterable": false | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "mappings", | |
| "value": [ | |
| { | |
| "from": "0", | |
| "id": 1, | |
| "text": "WET ", | |
| "to": "0.8", | |
| "type": 2 | |
| }, | |
| { | |
| "from": "0.8", | |
| "id": 2, | |
| "text": "DRY", | |
| "to": "1", | |
| "type": 2 | |
| } | |
| ] | |
| }, | |
| { | |
| "id": "custom.width", | |
| "value": 103 | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "value index (mean)" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "custom.displayMode", | |
| "value": "basic" | |
| }, | |
| { | |
| "id": "unit", | |
| "value": "none" | |
| }, | |
| { | |
| "id": "decimals", | |
| "value": 2 | |
| }, | |
| { | |
| "id": "color", | |
| "value": { | |
| "fixedColor": "yellow", | |
| "mode": "fixed" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 12, | |
| "x": 12, | |
| "y": 33 | |
| }, | |
| "id": 16, | |
| "options": { | |
| "showHeader": true, | |
| "sortBy": [] | |
| }, | |
| "pluginVersion": "7.3.7", | |
| "targets": [ | |
| { | |
| "panelId": 26, | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "AVG heat index by Soil Moisture", | |
| "transformations": [ | |
| { | |
| "id": "seriesToColumns", | |
| "options": {} | |
| }, | |
| { | |
| "id": "groupBy", | |
| "options": { | |
| "fields": { | |
| "Time": { | |
| "aggregations": [], | |
| "operation": null | |
| }, | |
| "value height": { | |
| "aggregations": [], | |
| "operation": null | |
| }, | |
| "value humidity": { | |
| "aggregations": [], | |
| "operation": null | |
| }, | |
| "value index": { | |
| "aggregations": [ | |
| "mean" | |
| ], | |
| "operation": "aggregate" | |
| }, | |
| "value moisture": { | |
| "aggregations": [], | |
| "operation": "groupby" | |
| } | |
| } | |
| } | |
| } | |
| ], | |
| "type": "table" | |
| } | |
| ], | |
| "schemaVersion": 26, | |
| "style": "dark", | |
| "tags": [ | |
| "avocado", | |
| "monitoring" | |
| ], | |
| "templating": { | |
| "list": [ | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": true, | |
| "text": "30m", | |
| "value": "30m" | |
| }, | |
| "error": null, | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "aggregation", | |
| "options": [ | |
| { | |
| "selected": false, | |
| "text": "1s", | |
| "value": "1s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5s", | |
| "value": "5s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "10s", | |
| "value": "10s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "30s1m", | |
| "value": "30s1m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "3m", | |
| "value": "3m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5m", | |
| "value": "5m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "10m", | |
| "value": "10m" | |
| }, | |
| { | |
| "selected": true, | |
| "text": "30m", | |
| "value": "30m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1h", | |
| "value": "1h" | |
| } | |
| ], | |
| "query": "1s,5s,10s,30s1m,3m,5m,10m,30m,1h", | |
| "queryValue": "", | |
| "skipUrlSync": false, | |
| "type": "custom" | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now-2d", | |
| "to": "now" | |
| }, | |
| "timepicker": {}, | |
| "timezone": "", | |
| "title": "Avocado summary", | |
| "uid": "u3K50VBGk", | |
| "version": 76 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment