**Summary (2014-04-30) of wanted data, extracted from comments below:**
Note that ☑ means "Data included in [[ https://lists.wikimedia.org/pipermail/wikitech-l/2015-April/081421.html | monthly Phab stats email to wikitech-l ]]"
Note that for //all// items we have raw SQL queries handy.
* ☑ Volume of tasks created in last month
* ☑ Volume of tasks closed in last month
* ☑ Volume of tasks open in total
* ☑ Volume of contributors (any activity) in last month
* ☑ Volume of authors in last month
* ☑ Volume of resolvers in last month
* ☑ Median age of open tasks by priority
* ☑ Number of accounts created in last month
* ☑ Number of projects which have seen at least one task being moved from one column to another column on the project's workboard in the last calendar month
* ☐ Top 50 task commenters in last month
* ☐ Top 50 task creators in last month
* ☐ Usernames of those 50 users who closed (in any way) the most tasks in the last month
* ☐ Task IDs and number of subscribers per task, ordered by number of subscribers, for open tasks, for those 50 tasks with the highest number of subscribers
* ☐ 50 open tasks with the longest time without any action/modification
* ☐ The 50 open tasks which received the most comments in the last month
* ☐ The 50 open tasks which have the highest number of different users who have commented on them
-------
**Original task summary:**
//Reported upstream: https://secure.phabricator.com/T6041 //
Key metrics that we are getting from http://korma.wmflabs.org/ and we would still need, either through a Phabricator backend for Metrics Grimoire or something else:
[x] Volume of contributors (any activity), authors, resolvers - implemented via T1003
[x] Volume of tasks created, closed, open - implemented via T1003
[ ] Median age of unattended tasks (Needs triage AND Backlog AND no comments from !author)
[x] Median age of open tasks by priority (excluding Needs Volunteer) - implemented via T1003
[ ] Lists of main contributors TBD
All this by project, with a possibility to aggregate data of different projects. See what we have currently at
* [[ http://korma.wmflabs.org/browser/its.html | General Bugzilla metrics ]]
* [[ http://korma.wmflabs.org/browser/its-repos.html | By product ]]
* [[ http://korma.wmflabs.org/browser/bugzilla_response_time.html | Bugzilla response time ]]
Note that we will be limited by the data imported from Bugzilla -- see T246