Boss: one dashboard query
One query, one row per week from 2025-W01 to 2026-06-30: revenue, orders, new customers, repeat share and the 4-week moving average of revenue. Revenue counts items of non-cancelled orders. Empty weeks still appear.
task
Per week from 2025-W01 to 2026-06-30: revenue (items of non-cancelled orders), orders, new customers, repeat share (orders that are a customer's 2nd or later, 3 decimals, NULL for empty weeks) and the 4-week moving average of revenue (2 decimals).