Forum: Ruby-core Stats and numbers on redmine tickets

I calculated some data on the Ruby tickets on redmine (i.e. for the last 
13
months).

I'll call the age of closed tickets the number of days between the last
update and the creation (which could thus overestimate the time it was 
left
open). The age of open tickets is of course the number of days passed 
since
it was created.

Splitting the ages in a more or less log scale, we get:

** Age of tickets **
      |  ≤ 2 days | ≤ week | ≤ month | 1-3 months | more | Total
To do |         6 |     11 |      82 |        110 |  241 |   450
Done  |       369 |    123 |     117 |         74 |   30 |   713

If we consider tickets with age greater than a week (presumably "harder"
tickets):
*
* Tickets not closed within a week **
Created in 13 months:  654
Closed in that period: 221
Remaining:             433

This trend seem to get worse with longer timeframes. For instance, given 
the
fact that only 30 tickets were ever closed after 3 months, how long will 
it
take to close the 241 open tickets that are already older than 3 months?

And how can I help?

--------------
Below are some additional details for anyone interested.
To play with the Excel spreadsheet:
http://marc-andre.ca/posts/ruby-core/redmine.xls

More detailed distribution
** Age of tickets (detail) **
         |  ≤ 2 days | ≤ week | ≤ month | 1-3 months | more | Total
Assigned |           |        |       2 |          7 |   11 |    20
Feedback |           |        |         |          1 |   17 |    18
Open     |         6 |     11 |      80 |        102 |  213 |   412
Subtotal |         6 |     11 |      82 |        110 |  241 |   450

Closed   |       296 |    111 |     107 |         62 |   21 |   597
Rejected |        73 |     12 |      10 |         12 |    9 |   116
Subtotal |       369 |    123 |     117 |         74 |   30 |   713

Total    |       375 |    134 |     199 |        184 |  271 |  1163

Average and median are:
      |   Average |    Median
To do | ~4 months | ~3 months
Done  |   16 days |     1 day

A third of all tickets have been created by the following top 10
("Anonymous" included):
Kazuhiro NISHIYAMA    | 63
Roger Pack            | 63
Run Paint Run Run     | 49
Charlie Savage        | 44
Anonymous             | 38
Tadayoshi Funaba      | 27
Shyouhei Urabe        | 24
Takeyuki Fujioka      | 24
Dave Thomas           | 23
Yuki Sonoda           | 23

Maybe we need a clone of "the Month of PHP Bugs" ?

> Maybe we need a clone of "the Month of PHP Bugs" ?

I'd participate.

=r