The weekend sale made $127,000 more on Monday morning
transcript
Sunday night, the weekend sale made 2 point 43 million dollars. Monday morning, the same weekend made 127,000 more.
Sunday, a minute before midnight. Saturday: 1 point 2 5 million. Sunday: 1 point 1 8. Total: 2 point 43 million dollars. Monday, 9 AM. Saturday is up 62,000. Sunday is up 65,000. And the CFO asks: why did it change? Which one is right?
Mobile purchases made offline arrived late. The payment processor confirmed late. Manual orders were posted on Monday. The dashboard wasn't wrong. It was incomplete.
The easy move: overwrite the number in place. Then nobody can say what it showed yesterday, or why it moved.
So version it. Never update in place. Version 1, computed at 15:00: 50,000 dollars. Version 2, at 16:30. Reason: late data. 52,500. Version 3, after midnight. Reason: daily finalisation. 53,200. Final.
Each version keeps when, why, and the change. What did the screen show yesterday afternoon? An as-of query reproduces it. Operations reads latest. Finance reads final.
The live number wasn't wrong. It was early. Label it live or final. And version every change.
Full breakdown in the lecture.