Last active
March 7, 2021 11:52
-
-
Save ivanahuckova/d916188fe632642cb035e38e8718de3a 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": 5, | |
| "iteration": 1612022085048, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "datasource": "Avocado Metrics", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "cm" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 6, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 2, | |
| "options": { | |
| "colorMode": "background", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "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\"] == \"height\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> aggregateWindow(every: $aggregation, fn: last)\n |> yield(name: \"value\")", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🥑 height", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "Avocado Metrics", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "custom": {}, | |
| "displayName": "soil moisture", | |
| "mappings": [ | |
| { | |
| "from": "0.8", | |
| "id": 1, | |
| "text": "DRY", | |
| "to": "1", | |
| "type": 2 | |
| }, | |
| { | |
| "from": "0", | |
| "id": 2, | |
| "text": "WET", | |
| "to": "0.8", | |
| "type": 2, | |
| "value": "" | |
| } | |
| ], | |
| "max": 1, | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "dark-blue", | |
| "value": null | |
| }, | |
| { | |
| "color": "dark-red", | |
| "value": 0.8 | |
| } | |
| ] | |
| }, | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 6, | |
| "x": 6, | |
| "y": 0 | |
| }, | |
| "id": 5, | |
| "options": { | |
| "colorMode": "background", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "mean" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "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\"] == \"moisture\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> aggregateWindow(every: $aggregation, fn: mean)\n |> yield(name: \"last\")", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "💧soil moisture", | |
| "type": "stat" | |
| }, | |
| { | |
| "circleMaxSize": "15", | |
| "circleMinSize": "15", | |
| "colors": [ | |
| "#73BF69", | |
| "#73BF69", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "datasource": "Weather", | |
| "decimals": 0, | |
| "esMetric": "Count", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": { | |
| "align": null, | |
| "filterable": false | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 12, | |
| "x": 12, | |
| "y": 0 | |
| }, | |
| "hideEmpty": false, | |
| "hideZero": false, | |
| "id": 20, | |
| "initialZoom": "4", | |
| "locationData": "table", | |
| "mapCenter": "Europe", | |
| "mapCenterLatitude": 46, | |
| "mapCenterLongitude": 14, | |
| "maxDataPoints": 1, | |
| "mouseWheelZoom": true, | |
| "pluginVersion": "7.3.6", | |
| "showLegend": true, | |
| "stickyLabels": false, | |
| "tableQueryOptions": { | |
| "geohashField": "geohash", | |
| "labelField": "name", | |
| "latitudeField": "lat", | |
| "longitudeField": "lon", | |
| "metricField": "plants", | |
| "queryType": "coordinates" | |
| }, | |
| "targets": [ | |
| { | |
| "cacheDurationSeconds": 300, | |
| "fields": [ | |
| { | |
| "jsonPath": "$.coord.lon", | |
| "name": "" | |
| }, | |
| { | |
| "jsonPath": "$.coord.lat", | |
| "name": "" | |
| }, | |
| { | |
| "jsonPath": "$.name", | |
| "name": "", | |
| "type": "string" | |
| }, | |
| { | |
| "jsonPath": "$.cod", | |
| "name": "", | |
| "type": "number" | |
| } | |
| ], | |
| "queryParams": "q=Bratislava", | |
| "refId": "A", | |
| "urlPath": "" | |
| } | |
| ], | |
| "thresholds": "1,2", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🥑 location", | |
| "transformations": [ | |
| { | |
| "id": "calculateField", | |
| "options": { | |
| "alias": "plants", | |
| "binary": { | |
| "left": "cod", | |
| "operator": "/", | |
| "reducer": "sum", | |
| "right": "200" | |
| }, | |
| "mode": "binary", | |
| "reduce": { | |
| "reducer": "sum" | |
| } | |
| } | |
| } | |
| ], | |
| "type": "grafana-worldmap-panel", | |
| "unitPlural": "", | |
| "unitSingle": "", | |
| "unitSingular": "", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "humidity": "blue", | |
| "temperature": "red", | |
| "value": "blue" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Avocado Metrics", | |
| "decimals": 1, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "displayName": "temperature", | |
| "unit": "celsius" | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 7, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 12, | |
| "x": 0, | |
| "y": 9 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 3, | |
| "legend": { | |
| "avg": true, | |
| "current": true, | |
| "hideEmpty": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "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\"] == \"temperature\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\" and\n r._value > 10\n )\n |> aggregateWindow(every: $aggregation, fn: mean)\n |> yield(name: \"value\")", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "🌡 temperature", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "celsius", | |
| "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 | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "humidity": "blue", | |
| "temperature": "yellow", | |
| "value": "blue" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Avocado Metrics", | |
| "decimals": 1, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "displayName": "height", | |
| "unit": "cm" | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 8, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 12, | |
| "x": 12, | |
| "y": 9 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 16, | |
| "legend": { | |
| "avg": true, | |
| "current": true, | |
| "hideEmpty": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "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\"] == \"height\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\"\n and r._value > 15\n and r._value < 30\n )\n |> aggregateWindow(every: $aggregation, fn: mean)\n |> yield(name: \"value\")", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "🌱height", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "cm", | |
| "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 | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "heat index": "semi-dark-orange", | |
| "humidity": "blue", | |
| "temperature": "yellow", | |
| "value": "blue" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Avocado Metrics", | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "displayName": "heat index", | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 12, | |
| "x": 0, | |
| "y": 18 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 6, | |
| "legend": { | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "heat index", | |
| "fill": 7 | |
| } | |
| ], | |
| "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\"] == \"index\")\n |> filter(fn: (r) => r[\"_field\"] == \"value\")\n |> aggregateWindow(every: $aggregation, fn: mean)\n |> yield(name: \"mean\")", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "🌦 heat index", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "none", | |
| "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 | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "heat index": "dark-blue", | |
| "humidity": "blue", | |
| "temperature": "yellow", | |
| "value": "blue" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Avocado Metrics", | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "displayName": "heat index", | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 12, | |
| "x": 12, | |
| "y": 18 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 18, | |
| "legend": { | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "heat index", | |
| "fill": 7 | |
| } | |
| ], | |
| "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": [] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "💧 humidity", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "none", | |
| "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 | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "heat index": "rgb(125, 70, 30)", | |
| "humidity": "blue", | |
| "temperature": "yellow", | |
| "value": "blue" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Avocado Metrics", | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "displayName": "heat index", | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 12, | |
| "x": 0, | |
| "y": 27 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 17, | |
| "legend": { | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "heat index", | |
| "fill": 7 | |
| } | |
| ], | |
| "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\"] == \"moisture\")\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": [] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "🌦 soil moisture", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "none", | |
| "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 | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "heat index": "yellow", | |
| "humidity": "blue", | |
| "temperature": "yellow", | |
| "value": "blue" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Avocado Metrics", | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "displayName": "heat index", | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 12, | |
| "x": 12, | |
| "y": 27 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 21, | |
| "legend": { | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "heat index", | |
| "fill": 7 | |
| } | |
| ], | |
| "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\"] == \"light\")\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": [] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "☀️ light", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "none", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "datasource": "grafanacloud-ivhuc-logs", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 18, | |
| "w": 24, | |
| "x": 0, | |
| "y": 36 | |
| }, | |
| "id": 8, | |
| "options": { | |
| "showLabels": false, | |
| "showTime": true, | |
| "sortOrder": "Descending", | |
| "wrapLogMessage": false | |
| }, | |
| "pluginVersion": "7.3.2", | |
| "targets": [ | |
| { | |
| "expr": "{plant_id=\"2020_12_17\"}", | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "🥑plant logs", | |
| "type": "logs" | |
| } | |
| ], | |
| "refresh": false, | |
| "schemaVersion": 26, | |
| "style": "dark", | |
| "tags": [ | |
| "avocado", | |
| "monitoring" | |
| ], | |
| "templating": { | |
| "list": [ | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": true, | |
| "text": "1h", | |
| "value": "1h" | |
| }, | |
| "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": "30s", | |
| "value": "30s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1m", | |
| "value": "1m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "3m", | |
| "value": "3m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5m", | |
| "value": "5m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "10m", | |
| "value": "10m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "20m", | |
| "value": "20m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "30m", | |
| "value": "30m" | |
| }, | |
| { | |
| "selected": true, | |
| "text": "1h", | |
| "value": "1h" | |
| } | |
| ], | |
| "query": "1s,5s,10s,30s,1m,3m,5m,10m,20m,30m,1h", | |
| "queryValue": "", | |
| "skipUrlSync": false, | |
| "type": "custom" | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now-7d", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ] | |
| }, | |
| "timezone": "", | |
| "title": "Avocado sensor data", | |
| "uid": "74RFvDoMk", | |
| "version": 104 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment