Interactive publication
Back to the cataloguePrecisionCase 01 of 05
Averaged timestamp
One timestamp that summarizes thousands of observations (a mean or a bucket label) is not an instant; the observations it stands for span a range and may cross slot boundaries.
Class
Case to account for
Affects
2 conversions
01
Detection
A single time represents an aggregate of many rows.
02
Mitigation
01
Carry the aggregation window (start, end) alongside the summary time; slot the window, not the mean.
03
Affected conversions
Slot + ISO weekUTC interval
OPENsemantics
OPEN