Bugs: Browse | Submit New | Admin

[#1153] stats seem semi-broken

Date:
2004-12-04 09:21
Priority:
3
Submitted By:
Ryan Davis (zenspider)
Assigned To:
Tom Copeland (tom)
Category:
Stats
State:
Open
Summary:
stats seem semi-broken

Detailed description
both ParseTree and RubyInline have had rankings of 0/0% on days when they obviously had activity. I'm not sure what
the algorithm is for the activity stats, but that seems wrong.

Add A Comment: Notepad

Please login


Followup

Message
Date: 2006-04-24 01:27
Sender: Tom Copeland

Hi Sascha -

Hm, yup, that should go away in a few more days... it's some
sort of problem in the part of that graphing stuff that deals
with there not being much data to work with.  It should go away
soon...

Yours,

tom
Date: 2006-04-22 13:40
Sender: Sascha Dördelmann

Statistics from Graphiclious show a "JpGraph Error"
and
subversion activities have never been recognized for the
whole lifetime of the project. As I don't have these
problems with my other projects, I thought that this was
a sign that subversion integration is not completed, yet.

Cheers
Sascha
Date: 2006-04-04 00:46
Sender: Tom Copeland

Another manifestation:

reproduce this bug like this:

1. open browser with URL http://rubyforge.org/
2. on the right, in the box "Most Active This Week"
click "[More]" in the bottom of the box
3. on the top of that page click "[View Other
Top Categories]"
4. click "Most Active All Time"

I obtain a page containing these lines:

Rank  	Project Name  	                        Percentile
  1	Ruby Rendezvous (ZeroConf) Service	40.47%
  2	RubyGems	                        93.46%
  3	p2501 	                                86.31%
  4	One-Click Ruby Installer	        92.25%
  5	Test 1	                                44.44%

What confuses me:
Percentile is not ordered numerically descending.  I would
expect
the highest percentile to come first.
Date: 2005-01-31 20:30
Sender: Tom Copeland

Logged In: YES 
user_id=102

You're right!  That is indeed quite odd...

Yours,

Tom
Date: 2005-01-29 09:53
Sender: Ryan Davis

Logged In: YES 
user_id=244

Evidence from the rubyforge support project itself. Obviously
you have days where activity is non-zero and you have a zero
rank. Other days (other than page views, you'll have non-zero
rank but zero activity). I'm not sure that SQL query is for the
ranking as displayed (which seems to be a running avg or something)
so much as it is for the ranking for that day.

   Date        Rank         Page Views D/l      Bugs   Support
Patches  All Trkr     Tasks CVS
   28 Jan 2005 28 ( 82.69 )          17  0   0 ( 0 )   0 ( 0
)   0 ( 0 )   0 ( 0 )   0 ( 0 )   0
   27 Jan 2005 44 ( 71.52 )          35  0   1 ( 1 )   0 ( 0
)   0 ( 0 )   1 ( 1 )   0 ( 0 )   3
   26 Jan 2005 0 ( 0.00 )            32  0   2 ( 0 )   0 ( 0
)   0 ( 0 )   2 ( 0 )   0 ( 0 )   0
   25 Jan 2005 0 ( 0.00 )            15  0   0 ( 0 )   0 ( 0
)   0 ( 0 )   0 ( 0 )   0 ( 0 )   0
   24 Jan 2005 80 ( 48.37 )          26  0   0 ( 0 )   0 ( 0
)   0 ( 0 )   0 ( 1 )   0 ( 0 )   0
   23 Jan 2005 79 ( 50.32 )          13  0   0 ( 0 )   0 ( 0
)   0 ( 0 )   0 ( 0 )   0 ( 0 )   0
   22 Jan 2005 79 ( 51.55 )          30  0   0 ( 0 )   0 ( 0
)   0 ( 0 )   1 ( 0 )   0 ( 0 )   0
Date: 2004-12-10 22:39
Sender: Tom Copeland

Logged In: YES 
user_id=102

Hi Ryan -

If you have more thoughts on this, please reopen this bug!

Thanks,

Tom
Date: 2004-12-09 22:42
Sender: Tom Copeland

Logged In: YES 
user_id=102

Hm.  Nope, it's not intentional; for example, you can see on
the Windows installer project that when they did a rls on Nov
28 the activity level was non-zero:

http://rubyforge.org/project/stats/index.php?report=last_30&g
roup_id=167

On the parse tree project, it looks like Dec 2 had an activity
rating of zero:

http://rubyforge.org/project/stats/index.php?report=last_30&g
roup_id=439

which was the day before the release, right?

Also, an activity rating of zero can happen even if the project
gets a page view or two... the only things that count towards
the stats are the things in this WHERE clause:

release_count > 0
OR msg_posted > 0
OR msg_uniq_auth > 0
OR bugs_opened > 0
OR bugs_closed > 0
OR support_opened > 0
OR support_closed > 0
OR patches_opened > 0
OR patches_closed > 0
OR artifacts_opened > 0
OR artifacts_closed > 0
OR tasks_opened > 0
OR tasks_closed > 0
OR help_requests > 0;

At least, that's my understanding of the system.  The code for
this in GForge is not an attractive sight :-), at least, not
to a PHP novice like myself.

Yours,

Tom
Date: 2004-12-04 09:35
Sender: Ryan Davis

Logged In: YES 
user_id=244

hey... I just realized that I get a ranking of 0 on the days
I release something... is that intentional? it doesn't look like
I have versioned pageview/download stats, but I have no idea
what is going on under the covers... this didn't happen on SF,
so I still assume it was a bug.

also, if it is, any chance that the zero's can be recalculated
and fixed?

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

Field Old Value Date By
status_idClosed2005-01-29 09:54zenspider
category_idNone2005-01-29 09:54zenspider
close_date2005-01-29 09:532005-01-29 09:53zenspider
status_idOpen2004-12-10 22:39tom
close_date2004-12-10 22:392004-12-10 22:39tom
assigned_tonone2004-12-09 22:42tom