Incident Lab · SEV2 · Databricks
The daily gross bookings report doesn't match the Mumbai team's numbers
Ops (Mumbai): our daily gross bookings figures never match the dashboard. Totals over the three days agree, single days don't.
raw trips.ended at is stored in UTC . Metro Rides's business day is Mumbai time, UTC+5:30 (Mumbai) , and every report is supposed to use it. daily bookings groups by CAST(ended at AS DATE) . Investigate: which trips land on a different day in Mumbai? Fix daily bookings to group by the Mumbai day. Keep the columns day , trips and bookings (rounded to 2 decimals). Use a fixed offset of 330 minutes ( to minutes(330) ).