Incident Lab · SEV2 · Airflow
The segment breakdown of revenue adds up to more than the total
Finance: the segment breakdown of revenue sums to more than the company total since dim_customers started keeping history.
revenue by segment joins raw orders to dim customers on customer id . Last week dim customers started keeping history : when a customer changes segment, the old row stays with is current = false . The report should use each customer's current segment. Investigate: Fix the view so every order is counted once, under the current segment. Keep the columns segment and revenue (rounded to 2 decimals).