Test Coronavirus Statistics for ioBroker

[Dutchman]

@jackblackson sagte in Test Coronavirus Statistics for ioBroker:

@Dutchman Das mit den Tests ist cool. Aber die Zahl ist noch 0, auch auf deren Website, ich vermute mal, da sind sie erst noch am Einarbeiten, oder?

Bei mir ist da nix 0 ?

[jackblackson]

@Dutchman So sieht es bei mir aus, hab den Adapter grad extra nochmal neu gestartet:

[Dutchman]

@jackblackson sagte in Test Coronavirus Statistics for ioBroker:

@Dutchman So sieht es bei mir aus, hab den Adapter grad extra nochmal neu gestartet:

ah check, global totals und nicht die pro land.... ja der wert ist noch lehr in der API

https://corona.lmao.ninja/all

[crunchip]

@jackblackson bei coronavirus-statistics.0.global_continents.World_Sum.testsPerOneMillion wirst du fündig

[frankjoke]

Übrigens,

habe auf https://forum.iobroker.net/topic/31782/corona-daten-nach-mysql-importieren/16 gepostet dass ich eine kleine WebApp für Corona-Datenvenanalyse und Vergleich gemacht habe: https://frankjoke.github.io/coronafj/

[Dutchman]

@frankjoke sagte in Test Coronavirus Statistics for ioBroker:

https://frankjoke.github.io/coronafj/

nice

[MartyBr]

@frankjoke Sehr schöne Visualisierung. Gratulation.

[Hicki]

@crunchip sagte in Test Coronavirus Statistics for ioBroker:

Bei mir ist alles schwarz.
Habe ich was falsch gemacht?

[Hicki]

@crunchip sagte in Test Coronavirus Statistics for ioBroker:

für die, die es verwenden, habe die Ansicht Tageswerte für Deutschland und Global angepasst

für Deutschland

Spoiler

{
 "datasource": "InfluxDB-corona",
 "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
 }
}

für Global

Spoiler

{
 "datasource": "InfluxDB-corona",
 "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": {
   "avg": false,
   "current": true,
   "hideEmpty": false,
   "hideZero": false,
   "max": false,
   "min": false,
   "show": true,
   "total": false,
   "values": true,
   "alignAsTable": false
 },
 "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
 }
}

Bei mir ist alles schwarz.
Habe ich was falsch gemacht?

[crunchip]

@Hicki das kann ich dir nicht beantworten
Weiss ja nicht, was du gemacht hast
Wenn da das Gesamt Dashboard laufen hast, musst du für die jeweilige Abfrage die json ersetzen.

[Hicki]

@crunchip sagte in Test Coronavirus Statistics for ioBroker:

@Hicki das kann ich dir nicht beantworten
Weiss ja nicht, was du gemacht hast

Ich habe in Grafana unter Create, Import - paste JSON eingefügt. Ist doch richtig, oder?

[crunchip]

@Hicki das wäre richtig, wenn du das Gesamte Dashboard importieren würdest. Das sind aber zwei einzelne innerhalb eines Dashboard.
Hast du das Gesamte Dashboard laufen?

[Hicki]

@crunchip sagte in Test Coronavirus Statistics for ioBroker:

@Hicki das wäre richtig, wenn du das Gesamte Dashboard importieren würdest. Das sind aber zwei einzelne innerhalb eines Dashboard.
Hast du das Gesamte Dashboard laufen?

Ja

[crunchip]

@Hicki dann kannst du doch bei Tageswert Deutschland das Menü aufmachen, dort die json öffnen und die aktuell reinkopieren.
Bin leider nicht am Rechner, hab Nachtschicht.

[Hicki]

@crunchip sagte in Test Coronavirus Statistics for ioBroker:

@Hicki dann kannst du doch bei Tageswert Deutschland das Menü aufmachen, dort die json öffnen und die aktuell reinkopieren.
Bin leider nicht am Rechner, hab Nachtschicht.

Ok, ich melde mich Morgen noch einmal.
Danke erst einmal.

[crunchip]

@Hicki

[Hicki]

@crunchip sagte in Test Coronavirus Statistics for ioBroker:

@Hicki

Vielen Dank. Passt.
Ein Problem doch noch. Im Bild rot eingerahmt stehen zum Teil keine Werte. Was kann das sein?

[crunchip]

@Hicki da erscheinen nur die Werte, die aktuell übertragen wurden und die Berechnung ist 24Std Zyklus um 0:00
aktuell wäre es bei mir im Moment

[Hicki]

@crunchip sagte in Test Coronavirus Statistics for ioBroker:

@Hicki da erscheinen nur die Werte, die aktuell übertragen wurden und die Berechnung ist 24Std Zyklus um 0:00
aktuell wäre es bei mir im Moment

Was und wo muss ich jetzt da ändern?

[crunchip]

@Hicki wieso was ändern?, wen Daten kommen, werden die automatisch aktualisiert. Siehst du doch zum Vergleich auf deinem Dashboard rechts daneben.