Some of our metrics would benefit from more normalization. For example, Visual Editor template dialog opens make the most sense as a rate per Visual Editor session. Discuss any open questions and use aggregation scripts to produce any missing denominators.
If aggregation scripts will be adjusted, there is a [[ https://wikitech.wikimedia.org/wiki/Analytics/Systems/Reportupdater | help page ]] and the queries are in [[ https://github.com/wikimedia/analytics-reportupdater-queries/ | this repo ]].
##Wanted normalizations
| **context** | **goal** | **wanted** | **implementation** |
| CodeMirror ([[ https://grafana-rw.wikimedia.org/d/uXX3yj1Mz/codemirror?var-editorType=All&var-wiki=All | board ]]) | percentage of code mirror users per editor type | all users of a editor type (byEditor) | read editor types and codemirror settings from user_properties table https://gerrit.wikimedia.org/r/c/analytics/reportupdater-queries/+/657362 |
| VE TemplateDialog ([[ https://grafana-rw.wikimedia.org/d/FlNswa-Gz/ve-template-dialog?orgId=1 | board ]]) | percentage of “open” actions per VE pageview (session) | total number VE sessions by EditCount (Note that these are both sampled at 8.25%) | EditAttemptStep with editor_interface: visualeditor / wikitext-2017 & action: ready & user_editcount |