TAKmIVrVz.dashboard

{"meta": {"type": "db", "canSave": true, "canEdit": true, "canAdmin": true, "canStar": true, "canDelete": true, "slug": "energie-dashboard", "url": "/d/TAKmIVrVz/energie-dashboard", "expires": "0001-01-01T00:00:00Z", "created": "2023-06-29T11:32:25Z", "updated": "2023-06-29T11:37:13Z", "updatedBy": "lisann.bach@neuland21.de", "createdBy": "lisann.bach@neuland21.de", "version": 2, "hasAcl": false, "isFolder": false, "folderId": 26, "folderUid": "zjPWYTEVz", "folderTitle": "Admin & Editor", "folderUrl": "/dashboards/f/zjPWYTEVz/admin-and-editor", "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"}]}, "description": "", "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": 75, "links": [{"asDropdown": false, "icon": "dashboard", "includeVars": false, "keepTime": false, "tags": [], "targetBlank": false, "title": "Musterlink 1", "tooltip": "", "type": "link", "url": "https://grafana.bad-belzig.klima-daten.de/d/h2x-HdoVk/community-daten?orgId=1"}, {"asDropdown": false, "icon": "question", "includeVars": false, "keepTime": false, "tags": [], "targetBlank": false, "title": "Musterlink 2", "tooltip": "", "type": "link", "url": "https://grafana.bad-belzig.klima-daten.de/d/h2x-HdoVk/community-daten?orgId=1"}, {"asDropdown": false, "icon": "doc", "includeVars": false, "keepTime": false, "tags": [], "targetBlank": false, "title": "Musterlink 3", "tooltip": "", "type": "link", "url": "https://grafana.bad-belzig.klima-daten.de/d/h2x-HdoVk/community-daten?orgId=1"}, {"asDropdown": false, "icon": "info", "includeVars": false, "keepTime": false, "tags": [], "targetBlank": false, "title": "Impressum", "tooltip": "", "type": "link", "url": "https://bad-belzig.klima-daten.de/impressum/"}], "liveNow": false, "panels": [{"fieldConfig": {"defaults": {"color": {"mode": "palette-classic"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": {"type": "linear"}, "showPoints": "auto", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}, {"color": "red", "value": 80}]}}, "overrides": []}, "gridPos": {"h": 8, "w": 12, "x": 0, "y": 0}, "id": 18, "options": {"legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true}, "tooltip": {"mode": "single", "sort": "none"}}, "title": "Panel Title", "type": "timeseries"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "gridPos": {"h": 14, "w": 10, "x": 0, "y": 8}, "id": 4, "options": {"code": {"language": "plaintext", "showLineNumbers": false, "showMiniMap": false}, "content": "# Energie\n\n\n\nWillkommen auf dem Grafana-Dashboard zum Thema *Energie*. Hier findest du alle Daten-Visualisierungen von klima.daten Bad Belzig. Die Quellen zu den Daten findest du auf Github (https://github.com/Klima-Dashboard).\n\n\n![image](https://bad-belzig.klima-daten.de/wp-content/uploads/2023/01/kdbb-logo.png)\n\n\nFor markdown syntax help: [commonmark.org/help](https://commonmark.org/help/)", "mode": "markdown"}, "pluginVersion": "9.2.17", "transparent": true, "type": "text"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "continuous-GrYlRd"}, "displayName": "Arensnest Hausweide", "mappings": [], "max": 30, "min": -10, "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}, {"color": "red", "value": 80}]}, "unit": "celsius"}, "overrides": []}, "gridPos": {"h": 4, "w": 14, "x": 10, "y": 8}, "id": 14, "options": {"displayMode": "gradient", "minVizHeight": 10, "minVizWidth": 0, "orientation": "horizontal", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showUnfilled": true, "text": {}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "\nfrom(bucket: \"OpenSenseMap\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"638f1beb73c881001cbcc112\")\n  |> filter(fn: (r) => r[\"_field\"] == \"lastMeasurementValue\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "transparent": true, "type": "bargauge"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "Quelle: DWD\nhttp://www.dwd.de", "fieldConfig": {"defaults": {"color": {"mode": "palette-classic"}, "custom": {"axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": {"legend": false, "tooltip": false, "viz": false}, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": {"type": "linear"}, "showPoints": "auto", "spanNulls": false, "stacking": {"group": "A", "mode": "none"}, "thresholdsStyle": {"mode": "off"}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green", "value": null}, {"color": "red", "value": 80}]}}, "overrides": [{"matcher": {"id": "byName", "options": "p1Value"}, "properties": [{"id": "displayName", "value": "PM10"}]}, {"matcher": {"id": "byName", "options": "p2Value"}, "properties": [{"id": "displayName", "value": "PM2.5"}]}]}, "gridPos": {"h": 10, "w": 14, "x": 10, "y": 12}, "id": 6, "options": {"legend": {"calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true}, "tooltip": {"mode": "single", "sort": "none"}}, "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"Feinstaub\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"58256\")\n  |> filter(fn: (r) => r[\"_field\"] == \"p1Value\" or r[\"_field\"] == \"p2Value\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Niederschlag", "transformations": [], "type": "timeseries"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "custom": {"hideFrom": {"legend": false, "tooltip": false, "viz": false}}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "purple"}, {"color": "blue", "value": -1}, {"color": "green", "value": 0}, {"color": "#EAB839", "value": 1}, {"color": "orange", "value": 2}]}}, "overrides": []}, "gridPos": {"h": 11, "w": 10, "x": 0, "y": 22}, "id": 2, "options": {"basemap": {"config": {}, "name": "Layer 0", "type": "default"}, "controls": {"mouseWheelZoom": true, "showAttribution": true, "showDebug": false, "showMeasure": false, "showScale": true, "showZoom": true}, "layers": [{"config": {"showLegend": false, "style": {"color": {"fixed": "dark-green"}, "opacity": 1, "rotation": {"fixed": 0, "max": 360, "min": -360, "mode": "mod"}, "size": {"fixed": 5, "max": 15, "min": 2}, "symbol": {"fixed": "img/icons/marker/circle.svg", "mode": "fixed"}, "textConfig": {"fontSize": 12, "offsetX": 0, "offsetY": 0, "textAlign": "center", "textBaseline": "middle"}}}, "location": {"mode": "auto"}, "name": "Layer 1", "tooltip": false, "type": "markers"}], "tooltip": {"mode": "details"}, "view": {"allLayers": true, "id": "coords", "lat": 52.130442, "lon": 12.608295, "zoom": 11.02}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "  from(bucket: \"apw\")\n  |> range(start: 2006-12-01T23:30:00Z)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"38413485\" or r[\"_measurement\"] == \"37413750\" or r[\"_measurement\"] == \"38404661\" or r[\"_measurement\"] == \"38404670\" or r[\"_measurement\"] == \"38404690\" or r[\"_measurement\"] == \"38413420\" or r[\"_measurement\"] == \"38413421\" or r[\"_measurement\"] == \"38413430\" or r[\"_measurement\"] == \"38413440\" or r[\"_measurement\"] == \"38413441\" or r[\"_measurement\"] == \"38413442\" or r[\"_measurement\"] == \"38413443\" or r[\"_measurement\"] == \"38413453\" or r[\"_measurement\"] == \"38413454\" or r[\"_measurement\"] == \"38413470\" or r[\"_measurement\"] == \"38413471\" or r[\"_measurement\"] == \"38413472\" or r[\"_measurement\"] == \"38413486\" or r[\"_measurement\"] == \"38413490\" or r[\"_measurement\"] == \"38423150\" or r[\"_measurement\"] == \"38423250\" or r[\"_measurement\"] == \"39400001\" or r[\"_measurement\"] == \"39413095\" or r[\"_measurement\"] == \"39413110\" or r[\"_measurement\"] == \"39423102\")\n  |> filter(fn: (r) => r._field == \"status\" or r._field == \"longitude\" or r._field == \"latitude\")\n  |>last()\n  |> pivot(rowKey:[\"_time\"], columnKey: [\"_field\"], valueColumn: \"_value\")\n  |> group()  \n  |> drop(columns: [\"_start\", \"_stop\", \"_time\",\"_measurement\"])", "refId": "A"}], "transformations": [{"id": "organize", "options": {"excludeByName": {}, "indexByName": {}, "renameByName": {"p2Value": "Wert"}}}], "type": "geomap"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "gridPos": {"h": 6, "w": 14, "x": 10, "y": 22}, "id": 16, "options": {"code": {"language": "plaintext", "showLineNumbers": false, "showMiniMap": false}, "content": "# Title\n\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla vitae elit libero, a pharetra augue. Cras justo odio, dapibus ac facilisis in, egestas eget quam. Morbi leo risus, porta ac consectetur ac, vestibulum at eros. Donec ullamcorper nulla non metus auctor fringilla. Aenean eu leo quam. Pellentesque ornare sem lacinia quam venenatis vestibulum.", "mode": "markdown"}, "pluginVersion": "9.2.17", "title": "Panel Title", "type": "text"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "red", "value": 80}]}}, "overrides": []}, "gridPos": {"h": 6, "w": 4, "x": 10, "y": 28}, "id": 10, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showThresholdLabels": false, "showThresholdMarkers": true}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"OpenSenseMap\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"63981bc2a7390d001b0b5c56\")\n  |> filter(fn: (r) => r[\"_field\"] == \"lastMeasurementValue\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Temperatur (\u00b0C)", "type": "gauge"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "description": "", "fieldConfig": {"defaults": {"custom": {"hideFrom": {"legend": false, "tooltip": false, "viz": false}, "scaleDistribution": {"type": "linear"}}}, "overrides": []}, "gridPos": {"h": 14, "w": 10, "x": 14, "y": 28}, "id": 8, "options": {"calculate": false, "cellGap": 1, "color": {"exponent": 0.5, "fill": "dark-orange", "max": 30, "min": 3, "mode": "scheme", "reverse": true, "scale": "exponential", "scheme": "RdYlGn", "steps": 64}, "exemplars": {"color": "rgba(255,0,255,0.7)"}, "filterValues": {"le": 1e-09}, "legend": {"show": false, "showLegend": false}, "rowsFrame": {"layout": "ge"}, "tooltip": {"show": false, "yHistogram": false}, "yAxis": {"axisPlacement": "hidden", "reverse": false}}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"OpenSenseMap\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"63981bc2a7390d001b0b5c54\" or r[\"_measurement\"] == \"63981bc2a7390d001b0b5c53\" or r[\"_measurement\"] == \"63981bc2a7390d001b0b5c52\")\n  |> filter(fn: (r) => r[\"_field\"] == \"lastMeasurementValue\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")\n  ", "refId": "A"}], "title": "Bodenfeuchte Zukunftsschusterei", "type": "heatmap"}, {"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "fieldConfig": {"defaults": {"color": {"mode": "thresholds"}, "mappings": [], "thresholds": {"mode": "absolute", "steps": [{"color": "green"}, {"color": "red", "value": 80}]}}, "overrides": []}, "gridPos": {"h": 6, "w": 4, "x": 10, "y": 34}, "id": 12, "options": {"orientation": "auto", "reduceOptions": {"calcs": ["lastNotNull"], "fields": "", "values": false}, "showThresholdLabels": false, "showThresholdMarkers": true}, "pluginVersion": "9.2.17", "targets": [{"datasource": {"type": "influxdb", "uid": "HWTSokF4z"}, "query": "from(bucket: \"OpenSenseMap\")\n  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n  |> filter(fn: (r) => r[\"_measurement\"] == \"63981bc2a7390d001b0b5c4f\")\n  |> filter(fn: (r) => r[\"_field\"] == \"lastMeasurementValue\")\n  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n  |> yield(name: \"mean\")", "refId": "A"}], "title": "Bodentemperatur 50cm (\u00b0C)", "type": "gauge"}], "schemaVersion": 37, "style": "dark", "tags": [], "templating": {"list": []}, "time": {"from": "now-6h", "to": "now"}, "timepicker": {}, "timezone": "", "title": "Energie-Dashboard", "uid": "TAKmIVrVz", "version": 2, "weekStart": ""}}