Nobody chimed in on the discussion of this, https://www.mediawiki.org/wiki/Topic:Tq5qpc3emof83azo, but I still think it's important and am adding it to the list of metrics to include in the near future with Wikistats 2.0.
Description
Description
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Open | Feature | None | T44360 Provide regular cross-wiki reports on flagged revisions status | ||
Open | None | T177951 Add flagged revision status statistics to Wikistats 2.0 |
Event Timeline
Comment Actions
Any hope that this would go forward?
I think that low hanging fruit statistics with historical data for all wmf wikis with flaggedrevs enabled
1.) Median graph from flagged revs statistics table.
https://quarry.wmflabs.org/query/42183
select floor(frs_timestamp/1000000) as d, frs_stat_key, round(avg(frs_stat_val)) as avg_frs_stat_val from flaggedrevs_statistics where frs_stat_key="pendingLag-average" group by d
2.) Number of pending pages in content namespace
https://quarry.wmflabs.org/query/42184
select frs1.d, syncedpagesNS0, reviewedpagesNS0, reviewedPagesNS0 - syncedPagesNS0 as pending_pages from ( select floor(frs_timestamp/1000000) as d, frs_stat_key, round(avg(frs_stat_val)) as syncedPagesNS0 from flaggedrevs_statistics where frs_stat_key="syncedPages-NS:0" group by d ) as frs1, ( select floor(frs_timestamp/1000000) as d, frs_stat_key, round(avg(frs_stat_val)) as reviewedPagesNS0 from flaggedrevs_statistics where frs_stat_key="reviewedPages-NS:0" group by d ) as frs2 where frs1.d=frs2.d order by frs1.d;
Comment Actions
Putting on wikistats backlog. In the near team our plans are around reporting active editors for all wikis which is still a pending metric in wikistats so i doubt we would get to this.