I have been taking a look at various graphs. In many cases having 0 entries causes "interesting" things to show up... or rather not show up. For example, if there are very few snapshots to base daily activity graphs on, a graph may only cover part of the day. Part of this seems to be related to the fact the graphs appear to need at least one entry at both 23 and 0 hours to cover the whole day.
I am not sure, if it is possible to do the following, but it should increase overall info accuracy a lot. Set 1 entry of 0 to each of the 24 hours. This would mean that a server that does not get any reports, would show 24 entries of 0 per day... and get a very accurate "no activity reported" at the end of the month, because all servers would get an absolute minimum of 28(occasional 29)/30/31 x 24 entries each month. If there is a player report, it replaces the entry of 0. If there are multiple player reports for the same hour, they get added exactly as they do now.
In effect: Servers with no player made reports would show lines of 0. Servers with just 1 player made report would show a single spike and extremely low overall activity value. Servers with multiple player made reports would show reports very similar to the ones appearing now, but with 24 hour graphs and in cases where some timeperiod has no data, slightly lower overall activity.
As things are now, there are lots of servers, which have red figures and effectively 0% accuracy, many graphs are "broken" and in some cases the info ends up being very strange.
An example is EU-Ahn'Qiraj Realm, which as of this writing has one (1) Alliance entry of 670 and 141 Horde entries with an overall of 602. This means that according to completely unreliable Alliance data this server has much higher Alliace activity than Horde activity (which is very accurate for the time period of 17 to 8, but totally questionable from 9 to 16, because that period has NONE of the 141 entries).
The Alliance side has no graph and shows a flat average of 670. The Horde graph is "full", because it luckily has several 23 and 0 hour entries... but... it show a steady increase between 8 and 17, which can not be right, because a) players come and go and b) there is noone actively making snapshots.
If the changes I suggested were possible... Alliance would have a spike of 670 at 20 hours and overall activity of 28... and the Horde graph would look a bit different, but due to the hole in entries, overall activity would go down to 401.
Just because I curious, I am going to quit writing now and see if I can snapshot both sides to make 11 entries and then wait for the effects to be processed and entered and then look at the graphs again.
