Created
April 16, 2024 15:00
-
-
Save der-pw/d7ae83b56c8af303cfe30e2ad5a37e01 to your computer and use it in GitHub Desktop.
Grafna Dashboard Timelines bool-values and 3-state
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_INFLUXDB", | |
"label": "influxdb", | |
"description": "", | |
"type": "datasource", | |
"pluginId": "influxdb", | |
"pluginName": "InfluxDB" | |
} | |
], | |
"__elements": {}, | |
"__requires": [ | |
{ | |
"type": "grafana", | |
"id": "grafana", | |
"name": "Grafana", | |
"version": "10.4.1" | |
}, | |
{ | |
"type": "datasource", | |
"id": "influxdb", | |
"name": "InfluxDB", | |
"version": "1.0.0" | |
}, | |
{ | |
"type": "panel", | |
"id": "state-timeline", | |
"name": "State timeline", | |
"version": "" | |
} | |
], | |
"annotations": { | |
"list": [ | |
{ | |
"builtIn": 1, | |
"datasource": { | |
"type": "datasource", | |
"uid": "grafana" | |
}, | |
"enable": true, | |
"hide": true, | |
"iconColor": "rgba(0, 211, 255, 1)", | |
"name": "Annotations & Alerts", | |
"target": { | |
"limit": 100, | |
"matchAny": false, | |
"tags": [], | |
"type": "dashboard" | |
}, | |
"type": "dashboard" | |
} | |
] | |
}, | |
"editable": true, | |
"fiscalYearStartMonth": 0, | |
"graphTooltip": 0, | |
"id": null, | |
"links": [], | |
"liveNow": false, | |
"panels": [ | |
{ | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "continuous-GrYlRd" | |
}, | |
"custom": { | |
"fillOpacity": 100, | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"insertNulls": false, | |
"lineWidth": 0, | |
"spanNulls": 3600000 | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"false": { | |
"color": "semi-dark-blue", | |
"index": 1, | |
"text": "aus" | |
}, | |
"true": { | |
"color": "light-yellow", | |
"index": 2, | |
"text": "an" | |
} | |
}, | |
"type": "value" | |
}, | |
{ | |
"options": { | |
"result": { | |
"color": "semi-dark-purple", | |
"index": 0, | |
"text": "N/A" | |
} | |
}, | |
"type": "range" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
} | |
] | |
}, | |
"unit": "short" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 4, | |
"w": 24, | |
"x": 0, | |
"y": 0 | |
}, | |
"id": 3, | |
"options": { | |
"alignValue": "center", | |
"legend": { | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": false | |
}, | |
"mergeValues": true, | |
"rowHeight": 0.9, | |
"showValue": "always", | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"pluginVersion": "7.3.0-test", | |
"targets": [ | |
{ | |
"alias": "TV", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"Fernseher_state\" WHERE time >= ${__from}ms - 24h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
}, | |
{ | |
"alias": "Sz Lichterkette", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"Sz_Lichterkette_state\" WHERE time >= ${__from}ms - 24h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
}, | |
{ | |
"alias": "Allg. Anzeigetafel 1", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"Allg_Anzeigetafel1_state\" WHERE time >= ${__from}ms - 24h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "C", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
} | |
], | |
"title": "Betriebszeiten", | |
"transparent": true, | |
"type": "state-timeline" | |
}, | |
{ | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"description": "", | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "continuous-GrYlRd" | |
}, | |
"custom": { | |
"fillOpacity": 100, | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"insertNulls": false, | |
"lineWidth": 5, | |
"spanNulls": false | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"false": { | |
"color": "green", | |
"index": 1, | |
"text": "anwesend" | |
}, | |
"true": { | |
"color": "semi-dark-red", | |
"index": 2, | |
"text": "abwesend" | |
} | |
}, | |
"type": "value" | |
}, | |
{ | |
"options": { | |
"result": { | |
"index": 0, | |
"text": "N/A" | |
} | |
}, | |
"type": "range" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "short" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 4, | |
"w": 24, | |
"x": 0, | |
"y": 4 | |
}, | |
"id": 4, | |
"options": { | |
"alignValue": "center", | |
"legend": { | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"mergeValues": true, | |
"rowHeight": 0.9, | |
"showValue": "always", | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"pluginVersion": "7.3.0-test", | |
"targets": [ | |
{ | |
"alias": "Patrick", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"Patrick_abwesend\" WHERE time >= ${__from}ms - 48h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
}, | |
{ | |
"alias": "Larissa", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"Larissa_abwesend\" WHERE time >= ${__from}ms - 48h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
} | |
], | |
"title": "Anwesenheitsübersicht", | |
"transparent": true, | |
"type": "state-timeline" | |
}, | |
{ | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"description": "Zeigt ob und welche Fenster, geöffnet oder gekippt sind.", | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"fixedColor": "green", | |
"mode": "continuous-GrYlRd" | |
}, | |
"custom": { | |
"fillOpacity": 75, | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"insertNulls": false, | |
"lineWidth": 0, | |
"spanNulls": false | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"0": { | |
"color": "semi-dark-green", | |
"index": 3, | |
"text": "geschlossen" | |
}, | |
"1": { | |
"color": "light-yellow", | |
"index": 2, | |
"text": "gekippt" | |
}, | |
"2": { | |
"color": "#c52b3d", | |
"index": 1, | |
"text": "offen" | |
} | |
}, | |
"type": "value" | |
}, | |
{ | |
"options": { | |
"result": { | |
"color": "purple", | |
"index": 0, | |
"text": "N/A" | |
} | |
}, | |
"type": "range" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
} | |
] | |
}, | |
"unit": "short" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 6, | |
"w": 24, | |
"x": 0, | |
"y": 8 | |
}, | |
"id": 5, | |
"options": { | |
"alignValue": "center", | |
"legend": { | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"mergeValues": true, | |
"rowHeight": 0.87, | |
"showValue": "always", | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"pluginVersion": "7.3.0-test", | |
"targets": [ | |
{ | |
"alias": "R Kü Fenster", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"3state_kueche_fenster-rechts\" WHERE time >= ${__from}ms - 48h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
}, | |
{ | |
"alias": "L Kü Fenster", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"3state_kueche_fenster-links\" WHERE time >= ${__from}ms - 48h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
}, | |
{ | |
"alias": "Sz Balkontür", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"3state_schlafzimmer_balkontuer\" WHERE time >= ${__from}ms - 48h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "C", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
}, | |
{ | |
"alias": "Wz Balkontür", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"3state_wohnzimmer_balkontuer\" WHERE time >= ${__from}ms - 48h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "D", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
}, | |
{ | |
"alias": "Kinderzimmer", | |
"datasource": { | |
"type": "influxdb", | |
"uid": "${DS_INFLUXDB}" | |
}, | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"previous" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"limit": "", | |
"measurement": "Patrick_away", | |
"orderByTime": "ASC", | |
"policy": "global", | |
"query": "SELECT last(\"value\") FROM \"global\".\"3state_kinderzimmer_fenster\" WHERE time >= ${__from}ms - 48h AND time <= ${__to}ms GROUP BY time($__interval) fill(previous)", | |
"rawQuery": true, | |
"refId": "E", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [], | |
"tz": "" | |
} | |
], | |
"title": "Fensterstatus", | |
"transparent": true, | |
"type": "state-timeline" | |
} | |
], | |
"refresh": "", | |
"schemaVersion": 39, | |
"tags": [], | |
"templating": { | |
"list": [] | |
}, | |
"time": { | |
"from": "now-24h", | |
"to": "now" | |
}, | |
"timepicker": {}, | |
"timezone": "", | |
"title": "Status Zeitleisten", | |
"uid": "_7CFLIcGz", | |
"version": 2, | |
"weekStart": "" | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment