Page MenuHomePhabricator

Update dataset/query of Active Editors metric
Closed, ResolvedPublic

Description

Change source dataset/query of the active editors metric charts in the Editors-metrics dashboard on Superset to use wmf_product.active_editors instead of cchen. repo_active_editors.

Updates will be needed in the following charts-

  • Active Editors YoY
  • New and Returning Active Editors YoY
  • Active Editors by Market YoY
  • Active Editors by Project YoY
  • Active Editors by Project Family YoY

Event Timeline

mpopov triaged this task as Medium priority.May 17 2022, 5:16 PM
mpopov edited projects, added Product-Analytics (Kanban); removed Product-Analytics.

@Iflorez / @kzimmerman Available for review:
Active Editors YoY
New and Returning Active Editors YoY
Whats different?

Changed dataset to wmf_product.active_editors
Changed chart type to Time-Series Line Chart per advice from DE T301895#7924688
After a round of async reviews on Slack, I'll update the remaining Active Editor charts in the editors-metrics dashboard

From @Iflorez
Hi Maya,
My feedback:
These look good.
I like the new look on the visuals. And I like that the current year color shade is darker than previous years.
My only productive feedback at this time is that it might be easier for the presentations if we use the same color scale on the charts. These are both using a different color scheme. One is using D3 category 20b and the other is using D3 category 20c.

From @kzimmerman
Hi Maya! I’m sorry my review is late, thank you so much for your patience!
Active Editors YoY: Good choice for the chart color scheme, it helps make the current year more prominent. I suggest renaming the metrics so the legend is easier to read (from sum(active_editors) to something like Active Editors ). I just found out you can do that here: https://stackoverflow.com/a/55461119
New and Returning Active Editors YoY: I would suggest using the “D3 category 20” color scheme to create a more visual difference between new vs. active editors. Same note for renaming the metrics

Mayakp.wiki changed the task status from Open to In Progress.Jun 9 2022, 10:27 PM
Mayakp.wiki updated the task description. (Show Details)
Mayakp.wiki moved this task from Doing to Needs Review on the Product-Analytics (Kanban) board.

All Active Editors metrics charts have been updated with the dataset wmf_product.active_editors.

  • Chart type has been updated to Time Series Line chart for
    • Active Editors YoY
    • New and Returning Active Editors YoY
    • Active Editors by Market YoY