Which sales channel carried the quarter — and which one is coming up fast?
Online generated the highest revenue while Partner showed the strongest late-period growth — up 38% from June to July, against 10% for Online.
Online leads the two-month total; the gap to Retail is $7.8k.
bar · 1 dimension, 1 measure · 4 rows · highlight: Online · filters: Order date
SELECT channel,
ROUND(SUM(revenue) / 1000.0, 1) AS revenue_k
FROM sales
WHERE order_date BETWEEN '2026-06-01' AND '2026-07-31'
GROUP BY channel
ORDER BY revenue_k DESC
| channel | revenue_k |
|---|---|
| Online | 58.9 |
| Retail | 51.1 |
| Partner | 47.2 |
| Referral | 39.2 |
The total favours Online because it started the period ahead. The more interesting movement is underneath the total: month-on-month, the order is not the same as the standings.
Partner gains $7.6k month-on-month — the largest absolute and relative jump of any channel.
line · 1 date, 1 measure, by channel · 8 rows · highlight: Partner · filters: Order date
SELECT substr(order_date, 1, 7) AS month,
channel,
ROUND(SUM(revenue) / 1000.0, 1) AS revenue_k
FROM sales
WHERE order_date BETWEEN '2026-06-01' AND '2026-07-31'
GROUP BY month, channel
ORDER BY month, channel
| month | channel | revenue_k |
|---|---|---|
| 2026-06 | Partner | 19.8 |
| 2026-06 | Retail | 24.1 |
| 2026-06 | Referral | 16.7 |
| 2026-06 | Online | 28.0 |
| 2026-07 | Partner | 27.4 |
| 2026-07 | Retail | 27.0 |
| 2026-07 | Referral | 22.5 |
| 2026-07 | Online | 30.9 |
If July's pace holds, Partner passes Retail within a month and challenges Online by autumn. The recommendation that follows: keep supporting Online, but put the incremental sales effort where the slope is — Partner. The queries above are the argument; run them against next month's orders and the write-up updates itself.
Source: demonstration dataset — 43 orders across 6 products, prepared as orders + products → sales (42 rows; one orphan order excluded by the join).