For a TRUE 3-day rolling average we need every day in range to exist — zero-revenue days included. Otherwise the average drifts upward by hiding gaps.
Generate a calendar spine from 2026-05-10 through 2026-05-25 (inclusive). Days with no paid orders get daily_revenue = 0; then apply a trailing 3-row moving average over the densified series.
Round to 2 decimals.
Sort by day ascending. Result has 16 rows (one per day in range).