From: Urabe Shyouhei <shyouhei@...>
Date: 2009-07-02T17:19:26+09:00
Subject: [ruby-core:24114] Re: Stats and numbers on redmine tickets

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig11AEFF7A82BEDD49B9D291C2
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: quoted-printable

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

Marc-Andre Lafortune wrote:
> I calculated some data on the Ruby tickets on redmine (i.e. for the las=
t
> 13 months).
>=20
> 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.
>=20
> Splitting the ages in a more or less log scale, we get:
>=20
> ** 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
>=20
> 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
>=20
> This trend seem to get worse with longer timeframes. For instance, give=
n
> 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?
>=20
> And how can I help?
>=20
> --------------
> Below are some additional details for anyone interested.
> To play with the Excel spreadsheet:
> http://marc-andre.ca/posts/ruby-core/redmine.xls
>=20
> More detailed distribution
> ** Age of tickets (detail) **
>          |  =98 2 days | =98 week | =98 month | 1-3 months | more | Tot=
al
> Assigned |           |        |       2 |          7 |   11 |    20
> Feedback |           |        |         |          1 |   17 |    18
> Open     |         6 |     11 |      80 |        102 |  213 |   412
> Subtotal |         6 |     11 |      82 |        110 |  241 |   450
>                                           =20
> Closed   |       296 |    111 |     107 |         62 |   21 |   597
> Rejected |        73 |     12 |      10 |         12 |    9 |   116
> Subtotal |       369 |    123 |     117 |         74 |   30 |   713
>                                           =20
> Total    |       375 |    134 |     199 |        184 |  271 |  1163
>=20
> Average and median are:
>       |   Average |    Median
> To do | ~4 months | ~3 months
> Done  |   16 days |     1 day
>=20
> 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
>=20
>=20



--------------enig11AEFF7A82BEDD49B9D291C2
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkpMbXsACgkQuTXPUnA5eMLb9wCaAvOAui0gdburAYxZj/yUiWUe
VKgAn2MraLqucqRDTuxEmgvHsmvnx3K9
=fBiC
-----END PGP SIGNATURE-----

--------------enig11AEFF7A82BEDD49B9D291C2--