Last modified: 2014-01-03 16:11:31 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-190. Summary: Statistics on it.wiki RfD Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: mauro742 <mauro742@gmail.com> ------------------------------------------------------------------------------- From: Nickanc <nickanc.wiki@gmail.com> Date: Fri, 06 Jul 2012 13:57:42 ------------------------------------------------------------------------------- I need some statistics. Consider it.wikipedia and the prefix Wikipedia:Pagine da cancellare/ . I need to know, for every month since Jan 2010, how many edits, how many users edited per month in this prefix. Optionally, it would be great also if we could manage to calculate how many users were newbies when they edited in that prefix per month. Thank you very much!
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 06 Jul 2012 14:38:36 ------------------------------------------------------------------------------- Detecting if a user was new at a given time isn't trivial, so I left that out for now. Please notice, that IPs are counted as users as well. SQL: SELECT /* SLOW_OK */ COUNT(*) AS edit_count, COUNT(DISTINCT rev_user_text) AS user_count, LEFT(rev_timestamp, 6) AS month FROM page INNER JOIN revision ON rev_page = page_id WHERE page_namespace = 4 AND page_title LIKE 'Pagine_da_cancellare/%' AND LEFT(rev_timestamp, 6) > 201000 GROUP BY LEFT(rev_timestamp, 6); Result: http://toolserver.org/~hoo/dbq/dbq-190.txt (plain text)
------------------------------------------------------------------------------- From: Nickanc <nickanc.wiki@gmail.com> Date: Sun, 08 Jul 2012 17:03:32 ------------------------------------------------------------------------------- Ok, no problem for newbies. Maybe, is it possible to distinguish between registered users and IP? I mean, can we count both how many IPs edited per month and how many registered users edited per month?
------------------------------------------------------------------------------- From: Federico Leva <federicoleva@tiscali.it> Date: Mon, 16 Jul 2012 13:57:36 ------------------------------------------------------------------------------- We also need the average number of participants for request (with median and standard deviation). For the "newbies" part, ideally it would be interesting to count how many of those participants a) are sysops, b) have 1-50, 51-500, 501-5000, or 5001+ edits in each month.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: federicoleva@tiscali.it, hoo@online.de, nickanc.wiki@gmail.com
