Continuous Aggregate Refresh, Demystified: Invalidation, Lookback, and Late-Arriving Data

Yesterday the shift dashboard reported 41,900 units across an eight-hour window. Today the same query over the same eight hours reports 43,100. Nobody shipped a code change and nobody edited a row after the fact, so why did the number…