After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 325330 - Report to show number of users per points
Report to show number of users per points
Status: RESOLVED FIXED
Product: bugzilla.gnome.org
Classification: Infrastructure
Component: Reports
unspecified
Other Linux
: Normal enhancement
: ---
Assigned To: Bugzilla Maintainers
Bugzilla Maintainers
Depends on:
Blocks:
 
 
Reported: 2005-12-30 21:50 UTC by Karsten Bräckelmann
Modified: 2006-02-13 05:43 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Karsten Bräckelmann 2005-12-30 21:50:45 UTC 
Add a stats page about points and how many users currently have this score. Just a simple list, starting somwehere low and going up to the highest score, showing the number of users with this score.

Plus, maybe, a total count of users, etc...

Everyody is curious. Everybody wants to see how he compares to others. :)
Comment 1 Elijah Newren 2005-12-30 21:55:08 UTC 
Here's the intermediate answer, which we can probably turn into a report somewhere.  :)

mysql> select count(realname), points from profiles group by points order by points desc;
+-----------------+--------+
| count(realname) | points |
+-----------------+--------+
|               1 |     27 |
|               1 |     26 |
|               5 |     25 |
|               4 |     24 |
|               7 |     23 |
|              11 |     22 |
|              19 |     21 |
|              18 |     20 |
|              19 |     19 |
|              36 |     18 |
|              30 |     17 |
|              33 |     16 |
|              48 |     15 |
|              60 |     14 |
|              73 |     13 |
|              91 |     12 |
|             112 |     11 |
|             129 |     10 |
|             165 |      9 |
|             227 |      8 |
|             360 |      7 |
|             557 |      6 |
|             897 |      5 |
|            1705 |      4 |
|            4043 |      3 |
|           12890 |      2 |
|           48429 |      1 |
|           37468 |      0 |
+-----------------+--------+
28 rows in set (0.40 sec)
Comment 2 Elijah Newren 2006-02-13 05:43:01 UTC 
http://bugzilla.gnome.org/reports/points.cgi

Also linked to from http://bugzilla.gnome.org/page.cgi?id=points.html now.  :)