Last active
February 4, 2024 19:45
-
-
Save ivanahuckova/814a7963a2d22a37e09f128cc245be34 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
| { | |
| "__inputs": [ | |
| { | |
| "name": "DS_COLD-PLUNGE-FORM", | |
| "label": "cold-plunge-form", | |
| "description": "", | |
| "type": "datasource", | |
| "pluginId": "grafana-googlesheets-datasource", | |
| "pluginName": "Google Sheets" | |
| } | |
| ], | |
| "__elements": {}, | |
| "__requires": [ | |
| { | |
| "type": "panel", | |
| "id": "geomap", | |
| "name": "Geomap", | |
| "version": "" | |
| }, | |
| { | |
| "type": "grafana", | |
| "id": "grafana", | |
| "name": "Grafana", | |
| "version": "10.3.0-pre" | |
| }, | |
| { | |
| "type": "datasource", | |
| "id": "grafana-googlesheets-datasource", | |
| "name": "Google Sheets", | |
| "version": "1.2.5" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "stat", | |
| "name": "Stat", | |
| "version": "" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "table", | |
| "name": "Table", | |
| "version": "" | |
| } | |
| ], | |
| "annotations": { | |
| "list": [ | |
| { | |
| "builtIn": 1, | |
| "datasource": { | |
| "type": "grafana", | |
| "uid": "-- Grafana --" | |
| }, | |
| "enable": true, | |
| "hide": true, | |
| "iconColor": "rgba(0, 211, 255, 1)", | |
| "name": "Annotations & Alerts", | |
| "type": "dashboard" | |
| } | |
| ] | |
| }, | |
| "editable": true, | |
| "fiscalYearStartMonth": 0, | |
| "graphTooltip": 0, | |
| "id": null, | |
| "links": [], | |
| "liveNow": false, | |
| "panels": [ | |
| { | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "custom": { | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| } | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unitScale": true | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 21, | |
| "w": 13, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 2, | |
| "options": { | |
| "basemap": { | |
| "config": {}, | |
| "name": "Layer 0", | |
| "type": "default" | |
| }, | |
| "controls": { | |
| "mouseWheelZoom": true, | |
| "showAttribution": true, | |
| "showDebug": false, | |
| "showMeasure": false, | |
| "showScale": false, | |
| "showZoom": true | |
| }, | |
| "layers": [ | |
| { | |
| "config": {}, | |
| "filterData": { | |
| "id": "byRefId", | |
| "options": "A" | |
| }, | |
| "location": { | |
| "mode": "auto" | |
| }, | |
| "name": "Map", | |
| "tooltip": true, | |
| "type": "osm-standard" | |
| }, | |
| { | |
| "config": { | |
| "showLegend": true, | |
| "style": { | |
| "color": { | |
| "fixed": "dark-blue" | |
| }, | |
| "opacity": 0.7, | |
| "rotation": { | |
| "fixed": 0, | |
| "max": 360, | |
| "min": -360, | |
| "mode": "mod" | |
| }, | |
| "size": { | |
| "fixed": 10, | |
| "max": 50, | |
| "min": 1 | |
| }, | |
| "symbol": { | |
| "fixed": "img/icons/marker/circle.svg", | |
| "mode": "fixed" | |
| }, | |
| "symbolAlign": { | |
| "horizontal": "center", | |
| "vertical": "center" | |
| }, | |
| "text": { | |
| "field": "", | |
| "fixed": "", | |
| "mode": "field" | |
| }, | |
| "textConfig": { | |
| "fontSize": 12, | |
| "offsetX": 0, | |
| "offsetY": 0, | |
| "textAlign": "center", | |
| "textBaseline": "middle" | |
| } | |
| } | |
| }, | |
| "filterData": { | |
| "id": "byRefId", | |
| "options": "A" | |
| }, | |
| "location": { | |
| "mode": "auto" | |
| }, | |
| "name": "Plunges", | |
| "tooltip": true, | |
| "type": "markers" | |
| } | |
| ], | |
| "tooltip": { | |
| "mode": "details" | |
| }, | |
| "view": { | |
| "allLayers": true, | |
| "id": "coords", | |
| "lat": 48.268506, | |
| "lon": 17.193673, | |
| "zoom": 7.52 | |
| } | |
| }, | |
| "pluginVersion": "10.3.0-pre", | |
| "targets": [ | |
| { | |
| "cacheDurationSeconds": 0, | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "range": "plunges!A1:I", | |
| "refId": "A", | |
| "spreadsheet": "SPREADSHEET_ID" | |
| } | |
| ], | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Image link": true, | |
| "Time": true | |
| }, | |
| "includeByName": {}, | |
| "indexByName": {}, | |
| "renameByName": {} | |
| } | |
| } | |
| ], | |
| "type": "geomap" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": { | |
| "align": "auto", | |
| "cellOptions": { | |
| "type": "auto" | |
| }, | |
| "inspect": false | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unitScale": true | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Image link" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "links", | |
| "value": [ | |
| { | |
| "targetBlank": true, | |
| "title": "Show image", | |
| "url": "${__data.fields[\"Image link\"]}" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 11, | |
| "x": 13, | |
| "y": 0 | |
| }, | |
| "id": 1, | |
| "options": { | |
| "cellHeight": "sm", | |
| "footer": { | |
| "countRows": false, | |
| "fields": "", | |
| "reducer": [ | |
| "sum" | |
| ], | |
| "show": false | |
| }, | |
| "showHeader": true, | |
| "sortBy": [ | |
| { | |
| "desc": true, | |
| "displayName": "Time" | |
| } | |
| ] | |
| }, | |
| "pluginVersion": "10.3.0-pre", | |
| "targets": [ | |
| { | |
| "cacheDurationSeconds": 0, | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "range": "plunges!A1:I", | |
| "refId": "A", | |
| "spreadsheet": "SPREADSHEET_ID" | |
| } | |
| ], | |
| "title": "Plunges", | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Image": true, | |
| "Latitude": true, | |
| "Longitude": true, | |
| "Time": true | |
| }, | |
| "includeByName": {}, | |
| "indexByName": {}, | |
| "renameByName": {} | |
| } | |
| } | |
| ], | |
| "type": "table" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "blue", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "none", | |
| "unitScale": true | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 5, | |
| "x": 13, | |
| "y": 8 | |
| }, | |
| "id": 6, | |
| "options": { | |
| "colorMode": "background", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "count" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showPercentChange": false, | |
| "textMode": "value", | |
| "wideLayout": true | |
| }, | |
| "pluginVersion": "10.3.0-pre", | |
| "targets": [ | |
| { | |
| "cacheDurationSeconds": 0, | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "range": "plunges!A1:I", | |
| "refId": "A", | |
| "spreadsheet": "SPREADSHEET_ID" | |
| } | |
| ], | |
| "title": "Plunge count", | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Air temperature": true, | |
| "Date": true, | |
| "How long (seconds)": true, | |
| "Image": true, | |
| "Latitude": true, | |
| "Location": true, | |
| "Longitude": true, | |
| "Time": true, | |
| "Water temperature": false | |
| }, | |
| "includeByName": {}, | |
| "indexByName": {}, | |
| "renameByName": {} | |
| } | |
| } | |
| ], | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "blue", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "s", | |
| "unitScale": true | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 6, | |
| "x": 18, | |
| "y": 8 | |
| }, | |
| "id": 3, | |
| "options": { | |
| "colorMode": "background", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "mean" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showPercentChange": false, | |
| "textMode": "value", | |
| "wideLayout": true | |
| }, | |
| "pluginVersion": "10.3.0-pre", | |
| "targets": [ | |
| { | |
| "cacheDurationSeconds": 0, | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "range": "plunges!A1:I", | |
| "refId": "A", | |
| "spreadsheet": "SPREADSHEET_ID" | |
| } | |
| ], | |
| "title": "Average time in water", | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Air temperature": true, | |
| "Date": true, | |
| "How long (seconds)": false, | |
| "Image": true, | |
| "Latitude": true, | |
| "Location": true, | |
| "Longitude": true, | |
| "Time": true, | |
| "Water temperature": true | |
| }, | |
| "includeByName": {}, | |
| "indexByName": {}, | |
| "renameByName": {} | |
| } | |
| } | |
| ], | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "blue", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "celsius", | |
| "unitScale": true | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 5, | |
| "x": 13, | |
| "y": 14 | |
| }, | |
| "id": 5, | |
| "options": { | |
| "colorMode": "background", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "mean" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showPercentChange": false, | |
| "textMode": "value", | |
| "wideLayout": true | |
| }, | |
| "pluginVersion": "10.3.0-pre", | |
| "targets": [ | |
| { | |
| "cacheDurationSeconds": 0, | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "range": "plunges!A1:I", | |
| "refId": "A", | |
| "spreadsheet": "SPREADSHEET_ID" | |
| } | |
| ], | |
| "title": "Average air temperature", | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Air temperature": false, | |
| "Date": true, | |
| "How long (seconds)": true, | |
| "Image": true, | |
| "Latitude": true, | |
| "Location": true, | |
| "Longitude": true, | |
| "Time": true, | |
| "Water temperature": true | |
| }, | |
| "includeByName": {}, | |
| "indexByName": {}, | |
| "renameByName": {} | |
| } | |
| } | |
| ], | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "blue", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "celsius", | |
| "unitScale": true | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 6, | |
| "x": 18, | |
| "y": 14 | |
| }, | |
| "id": 4, | |
| "options": { | |
| "colorMode": "background", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "mean" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showPercentChange": false, | |
| "textMode": "value", | |
| "wideLayout": true | |
| }, | |
| "pluginVersion": "10.3.0-pre", | |
| "targets": [ | |
| { | |
| "cacheDurationSeconds": 0, | |
| "datasource": { | |
| "type": "grafana-googlesheets-datasource", | |
| "uid": "${DS_COLD-PLUNGE-FORM}" | |
| }, | |
| "range": "plunges!A1:I", | |
| "refId": "A", | |
| "spreadsheet": "SPREADSHEET_ID" | |
| } | |
| ], | |
| "title": "Average water temperature", | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Air temperature": true, | |
| "Date": true, | |
| "How long (seconds)": true, | |
| "Image": true, | |
| "Latitude": true, | |
| "Location": true, | |
| "Longitude": true, | |
| "Time": true, | |
| "Water temperature": false | |
| }, | |
| "includeByName": {}, | |
| "indexByName": {}, | |
| "renameByName": {} | |
| } | |
| } | |
| ], | |
| "type": "stat" | |
| } | |
| ], | |
| "refresh": "", | |
| "schemaVersion": 39, | |
| "tags": [], | |
| "templating": { | |
| "list": [] | |
| }, | |
| "time": { | |
| "from": "now-6h", | |
| "to": "now" | |
| }, | |
| "timepicker": {}, | |
| "timezone": "", | |
| "title": "Cold plunges", | |
| "uid": "cold-plunges", | |
| "version": 1, | |
| "weekStart": "" | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment