Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "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": 1,
- "links": [],
- "panels": [
- {
- "datasource": null,
- "description": "",
- "fieldConfig": {
- "defaults": {},
- "overrides": []
- },
- "gridPos": {
- "h": 8,
- "w": 24,
- "x": 0,
- "y": 0
- },
- "id": 4,
- "options": {
- "bgColor": "rgb(46, 0, 66)",
- "clockType": "24 hour",
- "countdownSettings": {
- "endCountdownTime": "2021-05-19T18:19:27+02:00",
- "endText": "00:00:00"
- },
- "dateSettings": {
- "dateFormat": "dddd, DD. MMMM YYYY",
- "fontSize": "48px",
- "fontWeight": "normal",
- "showDate": true
- },
- "mode": "time",
- "timeSettings": {
- "fontSize": "112px",
- "fontWeight": "bold"
- },
- "timezone": "",
- "timezoneSettings": {
- "fontSize": "12px",
- "fontWeight": "normal",
- "showTimezone": false,
- "zoneFormat": "offsetAbbv"
- }
- },
- "pluginVersion": "7.5.6",
- "targets": [
- {
- "format": "time_series",
- "group": [],
- "metricColumn": "none",
- "rawQuery": false,
- "rawSql": "SELECT\n RecordTime AS \"time\",\n RecordValue\nFROM TimeElements\nWHERE\n $__timeFilter(RecordTime)\nORDER BY RecordTime",
- "refId": "A",
- "select": [
- [
- {
- "params": [
- "RecordValue"
- ],
- "type": "column"
- }
- ]
- ],
- "table": "TimeElements",
- "timeColumn": "RecordTime",
- "timeColumnType": "timestamp",
- "where": [
- {
- "name": "$__timeFilter",
- "params": [],
- "type": "macro"
- }
- ]
- }
- ],
- "title": "Time",
- "type": "grafana-clock-panel"
- },
- {
- "aliasColors": {},
- "bars": false,
- "dashLength": 10,
- "dashes": false,
- "datasource": null,
- "fieldConfig": {
- "defaults": {},
- "overrides": []
- },
- "fill": 4,
- "fillGradient": 9,
- "gridPos": {
- "h": 8,
- "w": 24,
- "x": 0,
- "y": 8
- },
- "hiddenSeries": false,
- "id": 2,
- "interval": "1s",
- "legend": {
- "avg": true,
- "current": true,
- "max": true,
- "min": true,
- "show": true,
- "total": false,
- "values": true
- },
- "lines": true,
- "linewidth": 1,
- "maxDataPoints": null,
- "nullPointMode": "connected",
- "options": {
- "alertThreshold": true
- },
- "percentage": false,
- "pluginVersion": "7.5.7",
- "pointradius": 1,
- "points": false,
- "renderer": "flot",
- "seriesOverrides": [],
- "spaceLength": 10,
- "stack": false,
- "steppedLine": false,
- "targets": [
- {
- "format": "time_series",
- "group": [
- {
- "params": [
- "$__interval",
- "none"
- ],
- "type": "time"
- }
- ],
- "metricColumn": "none",
- "rawQuery": false,
- "rawSql": "SELECT\n $__timeGroupAlias(RecordTime,$__interval),\n avg(RecordValue) AS \"Light Level\"\nFROM TimeElements\nWHERE\n $__timeFilter(RecordTime)\nGROUP BY 1\nORDER BY $__timeGroup(RecordTime,$__interval)",
- "refId": "A",
- "select": [
- [
- {
- "params": [
- "RecordValue"
- ],
- "type": "column"
- },
- {
- "params": [
- "avg"
- ],
- "type": "aggregate"
- },
- {
- "params": [
- "Light Level"
- ],
- "type": "alias"
- }
- ]
- ],
- "table": "TimeElements",
- "timeColumn": "RecordTime",
- "timeColumnType": "timestamp",
- "where": [
- {
- "name": "$__timeFilter",
- "params": [],
- "type": "macro"
- }
- ]
- }
- ],
- "thresholds": [
- {
- "$$hashKey": "object:503",
- "colorMode": "custom",
- "fill": true,
- "fillColor": "rgba(50, 116, 217, 0.12)",
- "line": false,
- "lineColor": "rgba(31, 96, 196, 0.6)",
- "op": "gt",
- "value": 900,
- "yaxis": "left"
- },
- {
- "$$hashKey": "object:509",
- "colorMode": "custom",
- "fill": true,
- "fillColor": "rgba(196, 22, 42, 0.3)",
- "line": false,
- "lineColor": "rgba(31, 96, 196, 0.6)",
- "op": "lt",
- "value": 500,
- "yaxis": "left"
- }
- ],
- "timeFrom": null,
- "timeRegions": [
- {
- "$$hashKey": "object:472",
- "colorMode": "background6",
- "fill": true,
- "fillColor": "rgba(234, 112, 112, 0.12)",
- "line": false,
- "lineColor": "rgba(237, 46, 24, 0.60)",
- "op": "time"
- }
- ],
- "timeShift": null,
- "title": "Light Level",
- "tooltip": {
- "shared": true,
- "sort": 0,
- "value_type": "individual"
- },
- "type": "graph",
- "xaxis": {
- "buckets": null,
- "mode": "time",
- "name": null,
- "show": true,
- "values": []
- },
- "yaxes": [
- {
- "$$hashKey": "object:293",
- "format": "short",
- "label": null,
- "logBase": 2,
- "max": "8001",
- "min": "64",
- "show": true
- },
- {
- "$$hashKey": "object:294",
- "format": "short",
- "label": null,
- "logBase": 1,
- "max": null,
- "min": null,
- "show": true
- }
- ],
- "yaxis": {
- "align": false,
- "alignLevel": null
- }
- },
- {
- "datasource": "TempAndHum",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "continuous-BlYlRd"
- },
- "decimals": 1,
- "mappings": [],
- "max": 38,
- "min": 12,
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
- },
- {
- "color": "red",
- "value": 80
- }
- ]
- },
- "unit": "celsius"
- },
- "overrides": []
- },
- "gridPos": {
- "h": 7,
- "w": 3,
- "x": 0,
- "y": 16
- },
- "id": 8,
- "options": {
- "reduceOptions": {
- "calcs": [
- "lastNotNull"
- ],
- "fields": "/^Temperature$/",
- "values": false
- },
- "showThresholdLabels": false,
- "showThresholdMarkers": true,
- "text": {}
- },
- "pluginVersion": "7.5.7",
- "targets": [
- {
- "format": "time_series",
- "group": [],
- "metricColumn": "none",
- "rawQuery": false,
- "rawSql": "SELECT\n RecordTime AS \"time\",\n Temperature\nFROM TempAndHumElements\nWHERE\n $__timeFilter(RecordTime)\nORDER BY RecordTime",
- "refId": "A",
- "select": [
- [
- {
- "params": [
- "Temperature"
- ],
- "type": "column"
- }
- ]
- ],
- "table": "TempAndHumElements",
- "timeColumn": "RecordTime",
- "timeColumnType": "datetime",
- "where": [
- {
- "name": "$__timeFilter",
- "params": [],
- "type": "macro"
- }
- ]
- }
- ],
- "type": "gauge"
- },
- {
- "datasource": "TempAndHum",
- "fieldConfig": {
- "defaults": {
- "color": {
- "mode": "continuous-BlYlRd"
- },
- "decimals": 0,
- "mappings": [],
- "max": 100,
- "min": 0,
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
- },
- {
- "color": "red",
- "value": 80
- }
- ]
- },
- "unit": "humidity"
- },
- "overrides": []
- },
- "gridPos": {
- "h": 7,
- "w": 3,
- "x": 3,
- "y": 16
- },
- "id": 10,
- "options": {
- "reduceOptions": {
- "calcs": [
- "lastNotNull"
- ],
- "fields": "",
- "values": false
- },
- "showThresholdLabels": false,
- "showThresholdMarkers": true,
- "text": {}
- },
- "pluginVersion": "7.5.7",
- "targets": [
- {
- "format": "time_series",
- "group": [],
- "metricColumn": "none",
- "rawQuery": false,
- "rawSql": "SELECT\n RecordTime AS \"time\",\n Humidity\nFROM TempAndHumElements\nWHERE\n $__timeFilter(RecordTime)\nORDER BY RecordTime",
- "refId": "A",
- "select": [
- [
- {
- "params": [
- "Humidity"
- ],
- "type": "column"
- }
- ]
- ],
- "table": "TempAndHumElements",
- "timeColumn": "RecordTime",
- "timeColumnType": "datetime",
- "where": [
- {
- "name": "$__timeFilter",
- "params": [],
- "type": "macro"
- }
- ]
- }
- ],
- "type": "gauge"
- },
- {
- "aliasColors": {
- "Humidity": "blue",
- "Temperature": "green"
- },
- "bars": false,
- "dashLength": 10,
- "dashes": false,
- "datasource": "TempAndHum",
- "fieldConfig": {
- "defaults": {},
- "overrides": []
- },
- "fill": 0,
- "fillGradient": 0,
- "gridPos": {
- "h": 7,
- "w": 18,
- "x": 6,
- "y": 16
- },
- "hiddenSeries": false,
- "id": 6,
- "legend": {
- "alignAsTable": true,
- "avg": true,
- "current": true,
- "hideEmpty": true,
- "hideZero": true,
- "max": true,
- "min": true,
- "rightSide": false,
- "show": true,
- "total": false,
- "values": true
- },
- "lines": true,
- "linewidth": 3,
- "nullPointMode": "connected",
- "options": {
- "alertThreshold": true
- },
- "percentage": false,
- "pluginVersion": "7.5.7",
- "pointradius": 2,
- "points": false,
- "renderer": "flot",
- "seriesOverrides": [
- {
- "$$hashKey": "object:170",
- "alias": "Temperature",
- "yaxis": 1
- },
- {
- "$$hashKey": "object:171",
- "alias": "Humidity",
- "yaxis": 2
- }
- ],
- "spaceLength": 10,
- "stack": false,
- "steppedLine": false,
- "targets": [
- {
- "format": "time_series",
- "group": [
- {
- "params": [
- "10s",
- "none"
- ],
- "type": "time"
- }
- ],
- "metricColumn": "none",
- "rawQuery": false,
- "rawSql": "SELECT\n $__timeGroupAlias(RecordTime,10s),\n avg(Humidity) AS \"Humidity\",\n avg(Temperature) AS \"Temperature\"\nFROM TempAndHumElements\nWHERE\n $__timeFilter(RecordTime)\nGROUP BY 1\nORDER BY $__timeGroup(RecordTime,10s)",
- "refId": "A",
- "select": [
- [
- {
- "params": [
- "Humidity"
- ],
- "type": "column"
- },
- {
- "params": [
- "avg"
- ],
- "type": "aggregate"
- },
- {
- "params": [
- "Humidity"
- ],
- "type": "alias"
- }
- ],
- [
- {
- "params": [
- "Temperature"
- ],
- "type": "column"
- },
- {
- "params": [
- "avg"
- ],
- "type": "aggregate"
- },
- {
- "params": [
- "Temperature"
- ],
- "type": "alias"
- }
- ]
- ],
- "table": "TempAndHumElements",
- "timeColumn": "RecordTime",
- "timeColumnType": "datetime",
- "where": [
- {
- "name": "$__timeFilter",
- "params": [],
- "type": "macro"
- }
- ]
- }
- ],
- "thresholds": [],
- "timeFrom": null,
- "timeRegions": [],
- "timeShift": null,
- "title": "Temperature & Humidity",
- "tooltip": {
- "shared": true,
- "sort": 0,
- "value_type": "individual"
- },
- "type": "graph",
- "xaxis": {
- "buckets": null,
- "mode": "time",
- "name": null,
- "show": true,
- "values": []
- },
- "yaxes": [
- {
- "$$hashKey": "object:378",
- "format": "celsius",
- "label": "Temperature",
- "logBase": 1,
- "max": "36",
- "min": "12",
- "show": true
- },
- {
- "$$hashKey": "object:379",
- "format": "humidity",
- "label": "Humidity",
- "logBase": 1,
- "max": "100",
- "min": "0",
- "show": true
- }
- ],
- "yaxis": {
- "align": false,
- "alignLevel": null
- }
- }
- ],
- "refresh": "1m",
- "schemaVersion": 27,
- "style": "dark",
- "tags": [],
- "templating": {
- "list": []
- },
- "time": {
- "from": "now-15m",
- "to": "now"
- },
- "timepicker": {},
- "timezone": "",
- "title": "Kiosk",
- "uid": "s3k2JPkRz",
- "version": 20
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement