wmk7cKl4z.dashboard

{"meta": {"type": "db", "canSave": true, "canEdit": true, "canAdmin": true, "canStar": true, "canDelete": true, "slug": "temperatur-und-niederschlag-im-monatsvergleich", "url": "/d/wmk7cKl4z/temperatur-und-niederschlag-im-monatsvergleich", "expires": "0001-01-01T00:00:00Z", "created": "2023-06-06T15:06:04Z", "updated": "2023-06-20T10:37:32Z", "updatedBy": "dk+klimadashboard@tpwd.de", "createdBy": "dk+klimadashboard@tpwd.de", "version": 9, "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": 62, "links": [], "liveNow": false, "panels": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"color": {"fixedColor": "#224f72", "mode": "fixed"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "bars", "fillOpacity": 100, "gradientMode": "none", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineInterpolation": "linear", "lineWidth": 0, "pointSize": 5, "scaleDistribution": {"type": "linear"}, "showPoints": "auto", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "decimals": 0, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "#27865a", "value": null}]}, "unit": "lengthmm"}, "overrides": [{"matcher": {"id": "byName", "options": "Temperatur"}, "properties": [{"id": "custom.drawStyle", "value": "line"}, {"id": "custom.lineInterpolation", "value": "linear"}, {"id": "custom.lineWidth", "value": 3}, {"id": "custom.fillOpacity", "value": 0}, {"id": "unit", "value": "celsius"}, {"id": "color", "value": {"fixedColor": "#c82b17", "mode": "fixed"}}, {"id": "custom.pointSize", "value": 12}, {"id": "custom.axisPlacement", "value": "left"}]}]}, "gridPos": {"h": 17, "w": 19, "x": 0, "y": 0}, "id": 3, "options": {"legend": {"calcs": [], "displayMode": "table", "placement": "bottom", "showLegend": true}, "tooltip": {"mode": "multi", "sort": "none"}}, "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"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "hide": false, "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_RR\" or r[\"_field\"] == \"MITTEL_1991_2020\" or r[\"_field\"] == \"MITTEL_1961_1990\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "B"}], "transformations": [{"id": "calculateField", "options": {"alias": "MITTEL_TEMP", "mode": "reduceRow", "reduce": {"include": ["MITTEL_TEMP_1961_1990 5546", "MITTEL_TEMP_1991_2020 5546"], "reducer": "mean"}, "replaceFields": false}}, {"id": "calculateField", "options": {"alias": "MITTEL", "mode": "reduceRow", "reduce": {"include": ["MITTEL_1961_1990 5546", "MITTEL_1991_2020 5546"], "reducer": "mean"}}}, {"id": "calculateField", "options": {"alias": "Temperatur", "binary": {"left": "MO_TT 5546", "operator": "-", "reducer": "sum", "right": "MITTEL_TEMP"}, "mode": "binary", "reduce": {"include": ["MO_RR 5546", "MITTEL"], "reducer": "diff"}, "replaceFields": false}}, {"id": "calculateField", "options": {"alias": "Niederschlag", "binary": {"left": "MO_RR 5546", "operator": "-", "reducer": "sum", "right": "MITTEL"}, "mode": "binary", "reduce": {"reducer": "sum"}}}, {"id": "organize", "options": {"excludeByName": {"MITTEL": true, "MITTEL_1961_1990 5546": true, "MITTEL_1991_2020 5546": true, "MITTEL_TEMP": true, "MITTEL_TEMP_1961_1990 5546": true, "MITTEL_TEMP_1991_2020 5546": true, "MO_RR 5546": true, "MO_TT 5546": true, "Niederschlagsmenge": false}, "indexByName": {"MITTEL": 4, "MITTEL_1961_1990 5546": 1, "MITTEL_1991_2020 5546": 2, "MITTEL_TEMP": 8, "MITTEL_TEMP_1961_1990 5546": 5, "MITTEL_TEMP_1991_2020 5546": 6, "MO_RR 5546": 3, "MO_TT 5546": 7, "Niederschlag": 9, "Temperatur": 10, "Time": 0}, "renameByName": {"Temperatur": ""}}}], "type": "timeseries"}], "schemaVersion": 37, "style": "dark", "tags": [], "templating": {"list": []}, "time": {"from": "now-12M", "to": "now"}, "timepicker": {}, "timezone": "", "title": "Temperatur und Niederschlag im Monatsvergleich", "uid": "wmk7cKl4z", "version": 9, "weekStart": ""}}