Yes, i am seeing those fields now in Turnilo, but not in Superset.

@Milimetric Thanks for working on this! i noticed the updates in hive table, but not in Superset/Turnilo. Are there any additional queries i need to update in refinery to make this work in Superset? Thanks again!

Thank you @Nuria! I just tried the new feature on the dashboard, very useful!

Thank you @Dzahn !!

hi @Dzahn, just sent via SMS! Thank you!

Hi @Dzahn , i see you are on the clinic duty this week. do i need to assign the ticker to you?

Currently the canonical table is created by this notebook occasionally.

Fields submitted for edit_hourly table:

Here is a current summary of findings:

Draft for editing metrics: https://superset.wikimedia.org/superset/dashboard/50/

Draft for SQL style guide: https://www.mediawiki.org/wiki/Product_Analytics/Query_Style_Guide

MTP metrics for Q1 and baseline : https://docs.google.com/document/d/1ZiYPl5-IKDIpT5cf3-UNIogrWUHJlwifgIi1FWChAqM/edit

Hi there! here's my request for Kerberos credentials for Hadoop access on stat100X and notebook100X. My username is conniecc1.

@kzimmerman do you mean for this Q4 2019/20 as goal or Q4 2018/19 as baseline.

Approaches to estimate the missing Global South New Editor Retention metrics for September

reviewed with the following changes:

• update canonical wikis table for missing wikis
• update queries:
  1. Monthly non-bot edits
  2. Bot Editing Proportion
  3. Anonymous Editing Proportion
  4. Mobile Editing Proportion
  5. Majority-mobile editors proportion
  6. Visual edits

The data is not available in Superset now, i believe @mpopov's dataset is only for testing, right?

Worldwide Readership (MTP metrics slide):
Content Interactions (pageviews + previews) by emerging vs. existing markets: Feasible
Content Growth (edits, net new content): NOT Feasible for Q1 only past 2 month is available (September and October)

Draft for style guide.

Slides and use cases available for PM salon: Superset/Turnilo Sharing

Metrics Added

The link is here.

• Projects: Considering the YoY % decrease in revert rate and revert volumes, wikidata, enwiki, dewiki, ruwiki, zhwiki, are showing a big drop in revert rate for past few months.
• Drops in revert rate are correlated to (non-bot) Edit Increase for some projects: The drop in recent revert rate is correlated to (non-bot) edit increases only in wikidata and commons. For some other projects (enwiki, dewiki, ruwiki, zhwiki, frwiki, itwiki). the increases in (non-bot) edits are small over time, and the drop in reverts result in the drop in revert rate.
• Drops in revert rate/reverts are not correlated to number of users (new & returning) who make reverts: By looking at the number of users who make reverts overtime by tenue and by project, the numbers didn't change much over YoY.

By looking at timeframe: 4/23/2019 - 9/10/2019

Thank you @mforns! I am able to access Hue now!

Just updated two versions in the doc https://docs.google.com/presentation/d/1n3HO9KfCiwhmk4HqPklAmIigQji7owwiRztvbEEwEBg/edit?usp=sharing

Visualization of YoY trend for net new content created monthly breakdown by content type.

Here's a mockup for annual key metric. Let me know if any thing need to be updated or change.

@kzimmerman the board slides are updated.

@elukey i update the password and it's working! i am able to log into the SWAP now. Thanks again!

@elukey looks like it's still not working :(

@elukey Thanks for the updates.

Thanks @elukey!

Thanks again for your help @colewhite !