From: Marc-Andre Lafortune Date: 2009-07-02T15:08:52+09:00 Subject: [ruby-core:24113] Stats and numbers on redmine tickets --0016363b9e58b2b7b1046db2c233 Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: quoted-printable 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 ** | =98 2 days | =98 week | =98 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 th= e 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) ** | =98 2 days | =98 week | =98 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 --0016363b9e58b2b7b1046db2c233 Content-Type: text/html; charset=KOI8-R Content-Transfer-Encoding: quoted-printable 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 th= e time it was left open). The age of open tickets is of course the number o= f days passed since it was created.

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

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

If we consider tick= ets with age greater than a week (presumably "harder" tickets):
* Tickets not cl= osed within a week *
Created in 13 months:=9A 654
Closed in that period: 221
R= emaining:=9A=9A=9A=9A=9A=9A=9A=9A=9A=9A=9A=9A 433

This trend seem to get worse with = longer timeframes. For instance, given the fact that only 30 tickets were e= ver 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 w= ith the Excel spreadsheet: http://marc-andre.ca/posts/ruby-core/redmine.xls

More detailed distribution
* Age of tickets (detail) *
=9A =9A =9A =9A=9A |=9A =98 2 days | =98 = week | =98 month | 1-3 months | more | Total
Assigned | =9A =9A =9A = =9A =9A | =9A =9A =9A =9A| =9A =9A =9A 2 | =9A =9A =9A =9A =9A7 | =9A 11 | = =9A =9A20
Feedback | =9A =9A =9A =9A =9A |= =9A =9A =9A =9A| =9A =9A =9A =9A | =9A =9A =9A =9A =9A1 | =9A 17 | =9A =9A= 18
Open =9A =9A | =9A =9A = =9A =9A 6 | =9A =9A 11 | =9A =9A =9A80 | =9A =9A =9A =9A102 | =9A213 | =9A = 412
Subtotal | =9A =9A =9A =9A 6 | =9A =9A= 11 | =9A =9A =9A82 | =9A =9A =9A =9A110 | =9A241 | =9A 450
=9A =9A =9A =9A =9A = =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =
Closed =9A | =9A =9A =9A 296 | =9A =9A111 | =9A = =9A 107 | =9A =9A =9A =9A 62 | =9A 21 | =9A 597
Rejected | =9A =9A =9A = =9A73 | =9A =9A 12 | =9A =9A =9A10 | =9A =9A =9A =9A 12 | =9A =9A9 | =9A 11= 6
Subtotal | =9A =9A =9A 369 | =9A =9A123 = | =9A =9A 117 | =9A =9A =9A =9A 74 | =9A 30 | =9A 713
=9A =9A =9A =9A =9A = =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =9A =
Total =9A =9A| =9A =9A =9A 375 | =9A =9A134 | = =9A =9A 199 | =9A =9A =9A =9A184 | =9A271 | =9A1163

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

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


--0016363b9e58b2b7b1046db2c233--