Trend

Trend widgets draw values over time or over ordered categories. Return the rows oldest first: the chart reads them in the query's order, and the last row is "now".

Line chart

One line per series.

Orders reported per week, a line per order type: choose type for Series.

SELECT date_trunc('week', reported_at)::date AS week, type, count(*) AS orders
FROM work_orders
WHERE ($VAR.period.from IS NULL OR reported_at >= $VAR.period.from)
  AND ($VAR.period.to IS NULL OR reported_at < $VAR.period.to)
GROUP BY 1, 2
ORDER BY 1

date_trunc cuts weeks in the viewer's time zone. Each type's line takes its label and color from the presentation of type in Database.

Previous period

A Date range variable also gives the period just before it: $VAR.period.prev_from and $VAR.period.prev_to. This month gives last month; Last 7 days the 7 days before. To compare both in one chart, return them as two value columns.

LINE

One line per series, over time or categories - oldest first.

Size: 6 × 4 of the 12-column grid, at least 3 × 3 · Also: series, thresholds, events, zoom, export

SELECT m::date AS month, (100 + 20 * extract(month FROM m))::int AS revenue FROM generate_series(date '2026-01-01', date '2026-12-01', interval '1 month') AS m

Area chart

The same roles and settings as a line chart, with the area below each line filled, and Stacked to stack the series. Unset, its value axis starts at 0. Cumulative revenue this year:

SELECT date_trunc('month', i.issued_on)::date AS month,
       sum(sum(ii.quantity * ii.unit_price))
         OVER (ORDER BY date_trunc('month', i.issued_on)) AS cumulative
FROM invoices i
JOIN invoice_items ii ON ii.invoice = i.id
WHERE i.status <> 'DRAFT'
  AND i.issued_on >= date_trunc('year', current_date)
GROUP BY 1
ORDER BY 1

AREA

Lines filled below - totals over time.

Size: 6 × 4 of the 12-column grid, at least 3 × 3 · Also: series, thresholds, events, zoom, export

SELECT m::date AS month, sum(10 + extract(month FROM m)::int) OVER (ORDER BY m) AS cumulative FROM generate_series(date '2026-01-01', date '2026-12-01', interval '1 month') AS m

Next steps

• Proportion: parts of a whole.
• Variables: the period and its presets.