Denormalized data before clear: 0 500 1 700 2 900 3 1100 4 1300 Aggregation data after clear: 0 0 1 0 2 0 3 0 4 0 Final (denormalized) aggregation data: 0 1500 1 2700 2 2900 3 3100 4 3300