1632605 - Create update orphan tracking dashboard in BigQuery - split out by channel

Status: RESOLVED FIXED

(Toolkit :: Application Update, task, P1)

Description

[Rachel Tublitz [:rachel]]

It looks like we can access update error data now via BiqQuery in ways that we could not previously when the update orphaning dash was created.

To start, let's make a simple dash that shows: The distribution of up to date/out of date (concern)/out of date (possible concern) over time, split out by channels.

Assuming that's do-able, I'll file follow ups to add for specific errors.

Logic by channel will be as follows:

• Release - up to date = major versions going back 2 behind release.
• Beta & Dev Edition - up to date = major versions matching release.
• Nightly - up to date = running a current weekly release.

Comment 1

[Rachel Tublitz [:rachel]]

WIP, dash lives here

This includes release only for now, working on adding the other channels next. Once those are added, I'll make these a bit easier to read, ie convert to %.

Comment 2

[Rachel Tublitz [:rachel]]

Add Nightly and resolved issues with the release query.

Final dashboard is https://sql.telemetry.mozilla.org/dashboard/update-orphans-over-time.