Grafana - Problem
-
Hallo,
ich musste meine Datenbank und Grafana neu aufsetzen. Jetzt werden nicht alle Daten angezeigt, siehe Bild.
Was habe ich falsch gemacht.
Tageswerte Deutschland:
{ "datasource": "InfluxDB", "aliasColors": { "Genesen": "dark-green", "Kritisch": "dark-purple", "Sterbefälle": "dark-red", "aktiv": "dark-orange", "infiziert": "dark-blue" }, "bars": true, "dashLength": 10, "dashes": false, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 12, "x": 0, "y": 13 }, "hiddenSeries": false, "id": 26, "legend": { "avg": false, "current": true, "hideEmpty": false, "hideZero": false, "max": false, "min": false, "show": true, "total": false, "values": true }, "lines": false, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [ { "alias": "Sterbefälle" }, { "alias": "Kritisch" }, { "alias": "aktiv" }, { "alias": "infiziert" }, { "alias": "Genesen" } ], "spaceLength": 10, "stack": true, "steppedLine": false, "targets": [ { "alias": "Kritisch", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.critical\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "infiziert", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.cases\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "aktiv", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.active\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Sterbefälle", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.deaths\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Genesen", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.recovered\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "7d", "timeRegions": [], "timeShift": null, "title": "Tageswerte Deutschland", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }und
Tageswerte Global
{ "datasource": "InfluxDB", "aliasColors": { "Genesen": "dark-green", "Kritisch": "dark-purple", "Sterbefälle": "dark-red", "aktiv": "dark-orange", "infiziert": "dark-blue" }, "bars": true, "dashLength": 10, "dashes": false, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 12, "x": 0, "y": 19 }, "hiddenSeries": false, "id": 27, "legend": { "alignAsTable": false, "avg": false, "current": true, "hideEmpty": false, "hideZero": false, "max": false, "min": false, "show": true, "total": false, "values": true }, "lines": false, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [ { "alias": "Sterbefälle" }, { "alias": "Kritisch" }, { "alias": "aktiv" }, { "alias": "Genesen" }, { "alias": "infiziert" } ], "spaceLength": 10, "stack": true, "steppedLine": false, "targets": [ { "alias": "Kritisch", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.critical\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "infiziert", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.cases\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "aktiv", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.active\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Sterbefälle", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.deaths\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Genesen", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.recovered\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "7d", "timeRegions": [], "timeShift": null, "title": "Tageswerte Global", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }Gruß Hicki
-
Hallo,
ich musste meine Datenbank und Grafana neu aufsetzen. Jetzt werden nicht alle Daten angezeigt, siehe Bild.
Was habe ich falsch gemacht.Tageswerte Deutschland:
{ "datasource": "InfluxDB", "aliasColors": { "Genesen": "dark-green", "Kritisch": "dark-purple", "Sterbefälle": "dark-red", "aktiv": "dark-orange", "infiziert": "dark-blue" }, "bars": true, "dashLength": 10, "dashes": false, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 12, "x": 0, "y": 13 }, "hiddenSeries": false, "id": 26, "legend": { "avg": false, "current": true, "hideEmpty": false, "hideZero": false, "max": false, "min": false, "show": true, "total": false, "values": true }, "lines": false, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [ { "alias": "Sterbefälle" }, { "alias": "Kritisch" }, { "alias": "aktiv" }, { "alias": "infiziert" }, { "alias": "Genesen" } ], "spaceLength": 10, "stack": true, "steppedLine": false, "targets": [ { "alias": "Kritisch", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.critical\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "infiziert", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.cases\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "aktiv", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.active\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Sterbefälle", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.deaths\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Genesen", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.recovered\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "7d", "timeRegions": [], "timeShift": null, "title": "Tageswerte Deutschland", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }und
Tageswerte Global
{ "datasource": "InfluxDB", "aliasColors": { "Genesen": "dark-green", "Kritisch": "dark-purple", "Sterbefälle": "dark-red", "aktiv": "dark-orange", "infiziert": "dark-blue" }, "bars": true, "dashLength": 10, "dashes": false, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 12, "x": 0, "y": 19 }, "hiddenSeries": false, "id": 27, "legend": { "alignAsTable": false, "avg": false, "current": true, "hideEmpty": false, "hideZero": false, "max": false, "min": false, "show": true, "total": false, "values": true }, "lines": false, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [ { "alias": "Sterbefälle" }, { "alias": "Kritisch" }, { "alias": "aktiv" }, { "alias": "Genesen" }, { "alias": "infiziert" } ], "spaceLength": 10, "stack": true, "steppedLine": false, "targets": [ { "alias": "Kritisch", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.critical\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "infiziert", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.cases\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "aktiv", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.active\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Sterbefälle", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.deaths\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Genesen", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.global_continents.World_Sum.recovered\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "7d", "timeRegions": [], "timeShift": null, "title": "Tageswerte Global", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }Gruß Hicki
@Hicki spontan würde ich sagen "Tageswerte Deutschland" und "Tageswerte Global" verweisen auf einen anderen oder nicht existierenden Tabelle in der Datenbank. Zeig mal Germany und Global zum Vergleich in folgender Form:
"SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.critical\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')"Was wahrscheinlich einfacher ist:
- Lösche die Panels "Tageswerte Deutschland" und "Tageswerte Global"
- Mach eine Kopie von "Germany" und "Global"
- Änder den Zeitbezug in den neuen Kopien
... dann hast du die gleichen Datenquellen.
-
@Hicki spontan würde ich sagen "Tageswerte Deutschland" und "Tageswerte Global" verweisen auf einen anderen oder nicht existierenden Tabelle in der Datenbank. Zeig mal Germany und Global zum Vergleich in folgender Form:
"SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.critical\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')"Was wahrscheinlich einfacher ist:
- Lösche die Panels "Tageswerte Deutschland" und "Tageswerte Global"
- Mach eine Kopie von "Germany" und "Global"
- Änder den Zeitbezug in den neuen Kopien
... dann hast du die gleichen Datenquellen.
@ftd sagte in Grafana - Problem:
Was wahrscheinlich einfacher ist:
- Lösche die Panels "Tageswerte Deutschland" und "Tageswerte Global"
- Mach eine Kopie von "Germany" und "Global"
- Änder den Zeitbezug in den neuen Kopien
... dann hast du die gleichen Datenquellen.
Ich habe noch nicht so viel Erfahrung. Kannst Du mir das bitte etwas verständlicher erklären?
Gruß Hicki
-
@Hicki spontan würde ich sagen "Tageswerte Deutschland" und "Tageswerte Global" verweisen auf einen anderen oder nicht existierenden Tabelle in der Datenbank. Zeig mal Germany und Global zum Vergleich in folgender Form:
"SELECT non_negative_difference(last(cumulative_sum))FROM (\nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.critical\" WHERE $timeFilter GROUP BY time(1d)\n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')"Was wahrscheinlich einfacher ist:
- Lösche die Panels "Tageswerte Deutschland" und "Tageswerte Global"
- Mach eine Kopie von "Germany" und "Global"
- Änder den Zeitbezug in den neuen Kopien
... dann hast du die gleichen Datenquellen.
@ftd es sind die gleichen Datenpunkte wie in der rechten Spalte,
@Hicki
als Beispiel für Germany.casesSELECT non_negative_difference(last(cumulative_sum))FROM ( SELECT cumulative_sum(non_negative_difference(last("value"))) FROM "coronavirus-statistics.0.Germany.cases" WHERE $timeFilter GROUP BY time($__interval) ) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin') -
@crunchip sagte in Grafana - Problem:
SELECT non_negative_difference(last(cumulative_sum))FROM (
vielen Dank.
jetzt sieht es so aus.
{ "datasource": "InfluxDB", "aliasColors": { "Genesen": "dark-green", "Kritisch": "dark-purple", "Sterbefälle": "dark-red", "aktiv": "dark-orange", "infiziert": "dark-blue" }, "bars": true, "dashLength": 10, "dashes": false, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 12, "x": 0, "y": 13 }, "hiddenSeries": false, "id": 26, "legend": { "avg": false, "current": true, "hideEmpty": false, "hideZero": false, "max": false, "min": false, "show": true, "total": false, "values": true }, "lines": false, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [ { "alias": "Sterbefälle" }, { "alias": "Kritisch" }, { "alias": "aktiv" }, { "alias": "infiziert" }, { "alias": "Genesen" } ], "spaceLength": 10, "stack": true, "steppedLine": false, "targets": [ { "alias": "Kritisch", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.critical\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "infiziert", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.cases\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')\n", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "aktiv", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.active\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Sterbefälle", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.deaths\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Genesen", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.recovered\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "7d", "timeRegions": [], "timeShift": null, "title": "Tageswerte Deutschland", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }Das ist doch auch nicht richtig, Oder?
-
@crunchip sagte in Grafana - Problem:
SELECT non_negative_difference(last(cumulative_sum))FROM (
vielen Dank.
jetzt sieht es so aus.
{ "datasource": "InfluxDB", "aliasColors": { "Genesen": "dark-green", "Kritisch": "dark-purple", "Sterbefälle": "dark-red", "aktiv": "dark-orange", "infiziert": "dark-blue" }, "bars": true, "dashLength": 10, "dashes": false, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 12, "x": 0, "y": 13 }, "hiddenSeries": false, "id": 26, "legend": { "avg": false, "current": true, "hideEmpty": false, "hideZero": false, "max": false, "min": false, "show": true, "total": false, "values": true }, "lines": false, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [ { "alias": "Sterbefälle" }, { "alias": "Kritisch" }, { "alias": "aktiv" }, { "alias": "infiziert" }, { "alias": "Genesen" } ], "spaceLength": 10, "stack": true, "steppedLine": false, "targets": [ { "alias": "Kritisch", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.critical\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "infiziert", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.cases\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')\n", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "aktiv", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.active\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Sterbefälle", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.deaths\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Genesen", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(cumulative_sum))FROM ( \nSELECT cumulative_sum(non_negative_difference(last(\"value\"))) FROM \"coronavirus-statistics.0.Germany.recovered\" WHERE $timeFilter GROUP BY time($__interval) \n) WHERE $timeFilter GROUP BY time(1d) tz('Europe/Berlin')", "rawQuery": true, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "7d", "timeRegions": [], "timeShift": null, "title": "Tageswerte Deutschland", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }Das ist doch auch nicht richtig, Oder?
@Hicki habs mal mit meinem verglichen, du hast ein Leerzeichen zu viel drin, weiss nicht ob das was ausmacht
($__interval) \n) ($__interval)\n) -
@Hicki habs mal mit meinem verglichen, du hast ein Leerzeichen zu viel drin, weiss nicht ob das was ausmacht
($__interval) \n) ($__interval)\n) -
@Hicki nimm mal meine komplette Json
-
@Hicki war die Zeile falsch, beimkopieren in den Spoiler passiert, habs oben geändert
-
@Hicki du zeigst gerade Global, das war die Json für Deutschland und meine Einstellung bezieht sich auf 14 days und nicht auf 7 days
-
@Hicki das füllt sich erst noch pro Tag/ein Balken, du hast ja erst Werte von Heute
-
Ich habe aber auch schon Daten von gestern. Wo änderst Du eigentlich die Zeitspanne(zB 14 Tage)?
@Hicki laut deinem Dashboard hast du nur Werte von heute, siehe ROTE LINIE
ändern kannst du hier
-
Funktioniert alles prima. Nochmals vielen Dank für Deine Hilfe.
Eine Frage hätte ich da noch. Wie kann man die Datumsanzeige ändern?
zB. von 05/08 (Monat/Tag) zu 08/05 (Tag/Monat)Gruß Hicki
@Hicki Welche Datums-Anzeige meinst du?
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren AnmeldenSupport us
277
Online32.8k
Benutzer82.8k
Themen1.3m
Beiträge