Time

Event Time vs Processing Time: Know Which Clock Your Numbers Are On

Every record has three timestamps: when it happened, when it arrived, and when it was processed. Group by the wrong one and past days keep changing.