Incident Lab · SEV2 · Databricks
The city breakdown of gross bookings adds up to more than the total
Ops: the city breakdown of gross bookings sums to more than the company total since dim_drivers started keeping history.
bookings by city joins raw trips to dim drivers on driver id . Last week dim drivers started keeping history : when a driver changes city, the old row stays with is current = false . The report should use each driver's current city. Investigate: Fix the view so every trip is counted once, under the current city. Keep the columns city and bookings (rounded to 2 decimals).