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.