Incident Lab · SEV2 · dbt
The plan breakdown of collected revenue adds up to more than the total
RevOps: the plan breakdown of collected revenue sums to more than the company total since dim_accounts started keeping history.
collected by plan joins raw payments to dim accounts on account id . Last week dim accounts started keeping history : when a account changes plan, the old row stays with is current = false . The report should use each account's current plan. Investigate: Fix the view so every payment is counted once, under the current plan. Keep the columns plan and collected (rounded to 2 decimals).