Why are some figures annualized (noted with a suffix) while others are period figures, all in the same column? This mixed treatment makes aggregation risky: summing annualized and period figures would double-count part of the year. Should we separate them into different columns? See /u/plg_idril_damodred/p/plot-0030.
[deleted]
Idril Damodred Need to sync on next steps here.
Yara Pillai This was flagged in the postmortem.
Duplicated.
Is /u/plg_idril_damodred/p/plot-0030 built from the same extract?
I see it. See /u/plg_idril_damodred/p/plot-0030.
Careful,
baseline changed definition in 2003.Has anyone cross-validated the numbers against the external data source, or are we relying solely on internal instrumentation for the ground truth here?
Is energy use per capita here?
Adam Andor 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. (edited to fix a unit)