Author Topic: Averages  (Read 1868 times)

Offline bollix47

  • Regular
  • *
  • Posts: 43
  • Karma: 0
Averages
« on: February 10, 2008, 01:10:33 PM »
Using the Daily Points History as an example the averages appear to be wrong.

There are 8 rows but the total amount per column appears to be being divided by 7.

Same is true for the daily points update history table except that there are 15 rows being divided by 14.

Offline Kakao

  • Administrator
  • Regular
  • *****
  • Posts: 198
  • Karma: 1
    • Facebook
Re: Averages
« Reply #1 on: February 10, 2008, 03:40:23 PM »
I will probably rewrite those pages. It will take a week or two.

Notice that the error only happens when the table is full. The Daily Points History will only be full on Sundays and the Update History will only be full at the last update of the day, currently at 23:00.

Here is the correct 2:00 update sum as it is now:


 62,016
 45,056
 50,048
 59,456
113,792
 68,224
 69,120
 65,792
 50,368
 53,568
 31,104
 94,720
 68,800
 78,336
910,400  Sum of 2:00 updates
 65,029   The sum divided by 14


There really are only 14 rows with data, which is the desired (or possible) behavior.
« Last Edit: February 10, 2008, 03:42:06 PM by Kakao »
Every criticism or suggestion from the user is a gift. Even if i disagree or don't answer. Obviously if there is real intellectual work on producing it the better.

Offline Kakao

  • Administrator
  • Regular
  • *****
  • Posts: 198
  • Karma: 1
    • Facebook
Re: Averages
« Reply #2 on: February 23, 2008, 12:07:13 AM »
I wrote a new table driver this time in Python to substitute the old one in PHP.

It is already working in the donor history page: http://kakaostats.com/up.php?u=873745

Now there is a small average table.

In the next days I will also use the new driver in the donor summary, team history and team summary.

Every criticism or suggestion from the user is a gift. Even if i disagree or don't answer. Obviously if there is real intellectual work on producing it the better.