See T318494 for last quarter's steps to perform (Phab SQL; Bitergia)
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Aklapper | T324748 Quarterly Newsletter for January 2023 | |||
| Resolved | Aklapper | T319398 Community metrics 2022 Q4 for Technical Community Newsletter in January 2023 |
Event Timeline
Comment Actions
Phab SQL queries part:
- Phab: Number of Phab tasks created in Q4/2022:
- SELECT COUNT(tsk.dateCreated) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.dateCreated > 1664582399 AND tsk.dateCreated < 1672531200; = 6959
- Phab: Number of Phab tasks closed in Q4/2022:
- SELECT COUNT(tsk.closedEpoch) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.closedEpoch > 1664582399 AND tsk.closedEpoch < 1672531200; = 5236
- Phab: Number of different people who created Phab tasks in Q4/2022:
- SELECT COUNT(DISTINCT (tsk.authorPHID)) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.dateCreated > 1664582399 AND tsk.dateCreated < 1672531200; = 918
- Phab: Number of different people who closed Phab tasks in Q4/2022:
- SELECT COUNT(DISTINCT (tsk.closerPHID)) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.closedEpoch > 1664582399 AND tsk.closedEpoch < 1672531200; = 440
Comment Actions
=== Phabricator and Gerrit === * [[mw:Phabricator|Phabricator]]: Number of tasks created in Q4/2022: 6959 * Phabricator: Number of tasks closed in Q4/2022: 5236 * Phabricator: Number of different people who created tasks in Q4/2022: 918 * Phabricator: Number of different people who closed tasks in Q4/2022: 440 * [[mw:Gerrit|Gerrit]]: [https://wikimedia.biterg.io/goto/889f13169ca145e268abd7e487267d44 334 people wrote patches] ([https://wikimedia.biterg.io/goto/de9faa368423691358b2543f6333c7df 112 of them being volunteers]) in Q4/2022.