Scope
- How many active editors use Babels?
- How are the languages distributed?
Desired output
How many active editors use this?
- Population: active UI editors
How are the languages distributed?
- Population: Babels; Split: N, 5, 4, 3, 2, 1, 0
- Population: Babels; Split: N/5/4, 3/2/1, 0
- Population: active UI editors; Diagram: Number of Babels
- Population: active UI editors; Diagram: Number of N/5/4-Babels
- Population: active UI editors; typical combinations (optional)
- Population: active UI editors; most important bridge languages (optional)
Definitions:
Links:
Notes
MariaDB [wikidatawiki]> SELECT * FROM babel WHERE babel_user = (SELECT user_id FROM user WHERE user_name = 'Lydia Pintscher (WMDE)'); sudo -u analytics-wmde analytics-mysql metawiki MariaDB [metawiki]> SELECT * FROM babel WHERE babel_user = (SELECT user_id FROM user WHERE user_name = 'Lucas Werkmeister');
Lydia has contents in the wikidatawiki babel table because she has a local user page, whereas I don’t. and at read time, Babel::getUserLanguagesDB() reads from the local DB, then falls back to the central DB, if I’m reading the code correctly
Urgency
When this task should be completed by. If this task is time sensitive then please make this clear. Please also provide the date when the output will be used if there is a specific meeting or event, for example.
DD.MM.YYYY
Information below this point is filled out by the Wikidata Analytics team.
General Planning
Information is filled out by the analytics product manager.
Assignee Planning
Information is filled out by the assignee of this task.
Estimation
Estimate:
Actual:
Sub Tasks
Full breakdown of the steps to complete this task:
- subtask
Data to be used
See Analytics/Data_Lake for the breakdown of the data lake databases and tables.
The following tables will be referenced in this task:
- link_to_table
Notes and Questions
Things that came up during the completion of this task, questions to be answered and follow up tasks:
- Note