Washpoint Redemptions

Sum of LIFETIME_POINTS_REDEEMED across loyalty members whose last redemption falls in the selected window. Matches the legacy Power BI report.

Note: this is lifetime points-redeemed for customers who happened to redeem during the window — not the volume of points redeemed during the window itself. Mirrors the report leadership reviews each week.

Filters customers by DATE_POINTS_LAST_REDEEMED (Eastern).

By Location

Each customer is attributed to their first known location — earliest plan sign-up location from subscriptions. Customers with no subscription history are bucketed under "First Known Location".

Each point sums LIFETIME_POINTS_REDEEMED for customers whose last redemption fell on that day.