| 基线 | 近 7 日或近 4 周同期均值与中位数 |
|---|---|
| 区间 | 按分位数（如 P5 到 P95）设定 |
| 修正 | 节假日与大促单独建模或加白名单 |
| 触发 | 连续两次越界才升级，减少抖动误报 |
同星期基线对比
同星期基线对比
-- 与上周同星期对比
SELECT cur.dt, cur.cnt AS cur_cnt, pre.cnt AS last_week_cnt,
ROUND((cur.cnt - pre.cnt) / NULLIF(pre.cnt, 0), 4) AS wow_rate
FROM (SELECT dt, COUNT(1) AS cnt FROM dwd_trade_order_detail_di WHERE dt='2026-10-11' GROUP BY dt) cur
LEFT JOIN (SELECT dt, COUNT(1) AS cnt FROM dwd_trade_order_detail_di WHERE dt='2026-10-04' GROUP BY dt) pre
ON 1 = 1;基线模型要有业务日历输入，否则每逢节假日与促销都会产生批量误报。