0G3RFKlVk.dashboard

{"meta": {"type": "db", "canSave": true, "canEdit": true, "canAdmin": true, "canStar": true, "canDelete": true, "slug": "temperatur-im-monatsvergleich", "url": "/d/0G3RFKlVk/temperatur-im-monatsvergleich", "expires": "0001-01-01T00:00:00Z", "created": "2023-06-06T14:46:21Z", "updated": "2023-06-06T15:02:54Z", "updatedBy": "dk+klimadashboard@tpwd.de", "createdBy": "dk+klimadashboard@tpwd.de", "version": 5, "hasAcl": false, "isFolder": false, "folderId": 17, "folderUid": "VvFEcx1Vz", "folderTitle": "Deutscher Wetterdienst (DWD)", "folderUrl": "/dashboards/f/VvFEcx1Vz/deutscher-wetterdienst-dwd", "provisioned": false, "provisionedExternalId": "", "annotationsPermissions": {"dashboard": {"canAdd": true, "canEdit": true, "canDelete": true}, "organization": {"canAdd": true, "canEdit": true, "canDelete": true}}, "publicDashboardAccessToken": "", "publicDashboardUid": "", "publicDashboardEnabled": false}, "dashboard": {"annotations": {"list": [{"builtIn": 1, "datasource": {"type": "grafana", "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": 61, "links": [], "liveNow": false, "panels": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "fillOpacity": 80, "gradientMode": "scheme", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineWidth": 0, "scaleDistribution": {"type": "linear"}}, "decimals": 0, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "red", "value": null}, {"color": "#27865a", "value": 0}]}, "unit": "celsius"}, "overrides": []}, "gridPos": {"h": 17, "w": 19, "x": 0, "y": 0}, "id": 2, "options": {"barRadius": 0.25, "barWidth": 0.8, "groupWidth": 0.7, "legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": false}, "orientation": "auto", "showValue": "auto", "stacking": "none", "tooltip": {"mode": "single", "sort": "none"}, "xTickLabelRotation": 0, "xTickLabelSpacing": 0}, "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"DWD\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"5546\")\n  |> filter(fn: (r) => r[\"_field\"] == \"MO_TT\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Durchschnittstemperatur der letzten Monate", "transformations": [], "type": "barchart"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "fillOpacity": 80, "gradientMode": "scheme", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineWidth": 0, "scaleDistribution": {"type": "linear"}}, "decimals": 0, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a", "value": null}, {"color": "#c82b17", "value": 0}]}, "unit": "celsius"}, "overrides": []}, "gridPos": {"h": 17, "w": 19, "x": 0, "y": 17}, "id": 3, "options": {"barRadius": 0.25, "barWidth": 0.8, "groupWidth": 0.7, "legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": false}, "orientation": "auto", "showValue": "auto", "stacking": "none", "tooltip": {"mode": "single", "sort": "none"}, "xTickLabelRotation": 0, "xTickLabelSpacing": 0}, "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"DWD\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"5546\")\n  |> filter(fn: (r) => r[\"_field\"] == \"MO_TT\" or r[\"_field\"] == \"MITTEL_TEMP_1991_2020\" or r[\"_field\"] == \"MITTEL_TEMP_1961_1990\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Durchschnittstemperatur im Vergleich zum Mittel von 1961-2020", "transformations": [{"id": "calculateField", "options": {"alias": "MITTEL", "mode": "reduceRow", "reduce": {"include": ["MITTEL_TEMP_1961_1990 5546", "MITTEL_TEMP_1991_2020 5546"], "reducer": "mean"}, "replaceFields": false}}, {"id": "calculateField", "options": {"alias": "Temperatur", "binary": {"left": "MO_TT 5546", "operator": "-", "reducer": "sum", "right": "MITTEL"}, "mode": "binary", "reduce": {"include": ["MO_RR 5546", "MITTEL"], "reducer": "diff"}, "replaceFields": true}}, {"id": "organize", "options": {"excludeByName": {"MITTEL": false, "MITTEL_1961_1990 5546": false, "MITTEL_1991_2020 5546": false, "MO_RR 5546": false, "Niederschlagsmenge": false}, "indexByName": {"MITTEL": 4, "MITTEL_1961_1990 5546": 1, "MITTEL_1991_2020 5546": 2, "MO_RR 5546": 3, "Niederschlagsmenge": 5, "Time": 0}, "renameByName": {}}}], "type": "barchart"}], "schemaVersion": 37, "style": "dark", "tags": [], "templating": {"list": []}, "time": {"from": "now-14M", "to": "now"}, "timepicker": {}, "timezone": "", "title": "Temperatur im Monatsvergleich", "uid": "0G3RFKlVk", "version": 5, "weekStart": ""}}