Is urban share per capita across the whole window?
urban share here is inverted; it should be in constant terms.
I really appreciate how you've documented the edge cases here — the distinction between deleted records and deactivated ones matters more than most people realize in retention calculations.
Need sign-off before we present this.
Works for me.