Minimal bar histogram (no axes); a table cell’s list(v ORDER BY i), or two overlaid series sharing one y scale from list({‘ref’: r, ‘cur’: c} ORDER BY i); on a map: a mini chart in each feature’s tooltip.
As ::SPARKLINE, drawn as bars; a list of {'ref': r, 'cur': c} overlays two series on one scale.
SELECT store ::TABLE, trend AS"Last 4 weeks" ::SPARKBAR
FROM (SELECT store, list(v ORDER BY t) AS trend
FROM (VALUES ('Berlin',1,5),('Berlin',2,7),('Berlin',3,6),('Berlin',4,9),('Hamburg',1,4),('Hamburg',2,3),('Hamburg',3,5),('Hamburg',4,4)) t(store, t, v) GROUP BY store);
SELECT'A **rich data table** — each column carries its own formatting role: **::MONEY** currency, **::COLORSCALE** heat-shaded cells, **::BADGE** status pills, **::TREND** an up/down arrow, an in-cell **::SPARKLINE**, and an in-cell **::SPARKBAR** (here two overlaid series: a flat reference share, muted, against each month''s actual share of the SKU''s total — one y scale per cell, so the bars stay comparable). One SELECT, per-column presentation. The second table adds options for the next table: **::TOTALS** picks each total (click a total''s tag to change it), **::COLGROUP** groups the header, **::FLAG** marks cells with ⚠, **::HIGHLIGHT** ranks the top n, and **::COLORSCALE_HIGH_GOOD** / **::COLORSCALE_DIVERGING** shade where high is good / around zero. The third groups its rows with **::SUBTOTAL** and marks each margin good / warn / bad with **::THRESHOLDS**.'::MARKDOWN, 'What this shows'::TITLE