| 键 | refund_id + 原 pay_id/order_id |
|---|---|
| 度量 | 退款金额/原因 |
| 配对 | 按原单聚合退款 |
退款率
退款率
SELECT o.dt, sum(r.refund_amt) / sum(o.pay_amt) AS refund_rate
FROM fact_order o
LEFT JOIN fact_refund r ON r.origin_order_id = o.order_id AND r.dt = o.dt
GROUP BY o.dt;跨期退款（本月退上月单）要按「退款发生月」与「原单月」双口径分别出数。