Maniphest T371212

[Analytics] Fix active_user_changes.sql query
Open, Needs TriagePublicBUG REPORT
Actions

Assigned To

None

Authored By

	• Manuel
	Jul 29 2024, 7:56 AM

Tags

Referenced Files

None

Subscribers

AndrewTavis_WMDE

Description

The query https://phabricator.wikimedia.org/diffusion/ADES/browse/master/src/wikidata/site_stats/sql/active_user_changes.sql is missing rc_type = 0 or similar.

This is where this data is used:
https://grafana.wikimedia.org/d/000000162/wikidata-site-stats?orgId=1&from=now-1M%2FM&to=now-1M%2FM

Related Objects

Mentioned In: T371215: [Analytics] [Request] Number of Wikidata editors with Rollback privileges
T371213: [Analytics] Number of active users editing the Wikidata namespaces on Wikidata
Mentioned Here: T371616: [EPIC][GRAFMIGR] Spruce up Wikidata Grafana Metrics

Event Timeline

• Manuel created this task.Jul 29 2024, 7:56 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 29 2024, 7:56 AM

• Manuel changed the subtype of this task from "Task" to "Bug Report".Jul 29 2024, 7:57 AM

• Manuel edited projects, added Wikidata Analytics (Kanban); removed Wikidata Analytics.

• Manuel mentioned this in T371213: [Analytics] Number of active users editing the Wikidata namespaces on Wikidata.Jul 29 2024, 8:01 AM

• Manuel updated the task description. (Show Details)Jul 29 2024, 8:12 AM

• Manuel updated the task description. (Show Details)

• Manuel updated the task description. (Show Details)

• Manuel mentioned this in T371215: [Analytics] [Request] Number of Wikidata editors with Rollback privileges .Jul 29 2024, 8:19 AM

• Manuel edited projects, added Wikidata Analytics; removed Wikidata Analytics (Kanban).Jul 31 2024, 8:19 AM

• Manuel moved this task from Incoming to Tasks Being Prepared for Backlog on the Wikidata Analytics board.

Could be included in T371616.

karapayneWMDE moved this task from Tasks Being Prepared for Backlog to Radar/Epics/Stalled on the Wikidata Analytics board.Jun 16 2025, 6:36 AM

karapayneWMDE edited projects, added Wikidata Analytics (Radar/Epics/Stalled); removed Wikidata Analytics.

karapayneWMDE moved this task from Incoming to Stale? on the Wikidata Analytics (Radar/Epics/Stalled) board.