Incident Lab · SEV2 · Airflow
The daily revenue report doesn't match the New York team's numbers
Finance (New York): our daily revenue figures never match the dashboard. Totals over the three days agree, single days don't.
raw orders.ordered at is stored in UTC . Northwind's business day is New York time, UTC−4 (New York, October) , and every report is supposed to use it. daily revenue groups by CAST(ordered at AS DATE) . Investigate: which orders land on a different day in New York? Fix daily revenue to group by the New York day. Keep the columns day , orders and revenue (rounded to 2 decimals). Use a fixed offset of -240 minutes ( to minutes(-240) ).