The proportional distribution across categories in a given year adds to 102% in some cases, suggesting either rounding artifacts or a data-entry error. The error is small but material enough for reconciliation. Should we investigate and correct the source, or should we renormalize? See /u/vgt_ruth_papadakis/p/plot-0343.
This reflects the current state.
The définition shifted in May without a corresponding update to the historical data — we're comparing apples from March–April against oranges from May onward, creating a false discontinuity.
Is this seasonality or a structural change?
This lines up with the other chart if you put life expectancy in absolute terms.
Good catch.
Can you tag the owner?
Can you split Q2 out?
That is a definition change, not a real move.
Makes sense, thanks.
Good catch.
Is the other chart built from the same extract?
We hit the same thing last Q3. The fix was to hold
raw_metric constant.Haldir Aybara Is this cálculos correct?
Can we see this by cohort?
That's the way to do it.
What happened to Norway around 2001?
That's a solid approach. See /u/vgt_ruth_papadakis/p/plot-0343.
Haldir Aybara That includes zeroed-out records.
Omar Boffin The error is subtle but significant — we're including the zero-value placeholder rows in the sum, which inflates the total by roughly 12% compared to when we filter them out explicitly in the query. See /u/vgt_ruth_papadakis/p/plot-0343.
The time window is wrong.
That matches what I had.
+1, and Kenya looks the same way.
Ruth Papadakis These aren't deduplicated.
Is this in absolute terms, or raw?
The tick marks are too frequent.
Agreed.
Should energy use be in constant terms for this comparison to mean anything? (edited to fix a unit)
Nice work on the breakdown.
Worth noting Poland and the UK are not measured the same way over the post-2020 window.
the left axis starts at zero for one series and not the other.
Nice — the H2 view helps.
Good catch.
Roger that.
See the other chart.
raised this on the other chart too, same a reporting lag.
Très bien — this level of detail on the assumptions is exactly what we need when presenting to stakeholders who might challenge the methodology downstream.
Can you split Q3 out?
+1, and MEA looks the same way.
Is the 2000 gap a reporting lag, or is the series genuinely missing?
Should we smooth the data? (edited to fix a unit)
Makes sense.
Fair enough.
The 2014 break is a currency effect — it shows up in every series from that source.
The font família on the mobile view doesn't match the desktop version — it's rendering too small even at the maximum size setting, making it nearly illegible.
Yep.
Why does Norway dip in 2021?
When we segment by région, does the trend hold for all five regions equally, or is the spike concentrated in one geographic area?
Are there known data gaps?
Sorry, lost me. What is the baseline?
The pattern makes sense.
Can we get automated alerts set up?
Your point about the compounding effect of the time zone offset across our geographically distributed user base is spot-on — that's exactly the kind of subtle bias that shifts quarterly results.
Fine by me.
Works for me.
Yes, exactly this.
+1, and Nigeria looks the same way.
Stale.
Sounds right.
Fixed.
Danke for your diligent work on this — it's the kind of thoroughness that prevents embarrassing discrepancies from slipping into published reports that executives rely on.
the y axis reads mislabelled.
Haldir Aybara This corresponds to the audit period.
See the other chart.
Same conclusion here.
+1, and Iberia looks the same way.
I agree.
Can we see APAC on the same scale?
Not sure what
Q3 is measuring.Is this the same chart as the other chart? It looks different.
Relates to the platform change on July 8. See /u/vgt_ruth_papadakis/p/plot-0343.
Should we be normalizing for the fact that some regions had incomplete data coverage for the first week of the month — does that skew the early numbers upward relative to the trailing week?
Stale.
No.
How is
Q3 derived?Minor: internet penetration is off in the tooltip.
Spot on.
The seasonal patterns in years past suggest we should expect 15–20% variance in Q3, but we're seeing 40% — is that a signal of a genuine structural break, or measurement noise?
Works for me.
Thanks , that resolves it.
Omar Boffin This was flagged in the postmortem.
Fully aligned.
Makes sense, thanks.
+1, and MEA looks the same way.