A new piece examines four approaches to maintaining report aggregates over a stream of receipts in ClickHouse and explains why each failed. The design ultimately kept recomputes aggregate cells from their underlying documents rather than adding up incremental values. It argues that an aggregate is a function, not a sum.