1772863 - plot null values as 0 in Looker graphs

Status: NEW

(Firefox :: General, enhancement, P3)

Description

[Marlene Hirose]

Update charts to plot null values as 0 so we don't see straight lines across a null value

https://mozilla.cloud.looker.com/dashboards/387?Submission+Date=90+day+ago+for+90+day

Comment 1

[Mike Williams [:mwilliams]]

Status update: most of the charts are already configured to plot nulls, and additionally are using the Looker feature to fill in missing dates with nulls. For charts using linear scale Y axis this is enough -- we see null values plotted as distinct values. If the chart uses a logarithmic scale, the axis starts at 1 and null is not plotted distinctly, so the line is interpolated between points with values. This is true even if we recalculate the null values as 0 (e.g., using COALESCE) -- Looker interprets/plots them the same.