Source: SQL over clover_orders per employee, filtered by ingested_at in [period_start, period_end).
One row per employee (latest period for the selected window). Older periods stay in the DB for trends but are not listed here.
Tip % formula: AVG(tip_total / bill × 100) where bill = COALESCE(payment_total, total), only when tip > 0 and tip ≤ bill.
Rebuilt: Rolling worker (hourly/daily/weekly). Use vs a live check: employee baseline boosters/suppressors.