aprsworld / mybergey

0 stars 0 forks source link

Incorrect 7 and 30 day energy produced values #13

Open aprsandrew opened 4 years ago

aprsandrew commented 4 years ago

The 7 and 30 day energy values seem to be calculated incorrectly when there is a couple days of missing data. In this instance, station A5518 had no data for 2020-08-06 and 2020-08-07, and while there was some data for 2020-08-08, there was not yet an entry in the summary_ps2tap_daily table for 2020-08-08 (presumably because there had been no data yet at the point that the script had run last. This seems to cause an issue with the energy calculations, and it shows extremely high energy production.

Manually entering some placeholder values in the summary_ps2tap_daily table for the missing days seems to have resolved the issue, but there should be a mechanism to properly deal with missing days of data.

Screenshot from 2020-08-08 21-03-26