Distribution and Relation

These widgets show where values concentrate: on a grid of two categories, on the days of the year, or as points placed by two numbers.

Heatmap

A grid of two categories, such as weekday × hour or branch × month, each cell colored by its value.

When Acme's customers report problems, over the last 90 days:

SELECT to_char(reported_at, 'Dy') AS weekday,
       to_char(reported_at, 'HH24') AS hour,
       count(*) AS orders
FROM work_orders
WHERE reported_at >= now() - interval '90 days'
GROUP BY 1, 2, extract(isodow FROM reported_at)
ORDER BY extract(isodow FROM reported_at), 2

A missing cell stays empty. For zeros, build the grid with generate_series and LEFT JOIN the data to it.

HEATMAP

A grid of two categories (day × hour, branch × month), each cell colored by its value; a missing cell stays empty.

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

SELECT (ARRAY['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun'])[d] AS weekday, lpad(h::text, 2, '0') AS hour, (random() * 100)::int AS readings FROM generate_series(1, 7) AS d, generate_series(0, 23) AS h ORDER BY d, h

Calendar heatmap

Every day of a year colored by its value: a year per row, as many of the latest three as fit. On a phone, the latest months that fit, with a notice when some are left out. Day and month names follow the viewer's language, and the week starts on the viewer's first day.

Visits scheduled per day:

SELECT scheduled_start::date AS day, count(*) AS visits
FROM visits
WHERE scheduled_start >= now() - interval '1 year'
GROUP BY 1
ORDER BY 1

scheduled_start::date cuts days in the viewer's time zone. Its settings are a heatmap's: Color, Thresholds, Format, Compact number, Show legend and On click (a click on a day).

CALENDAR

Every day of a year colored by its value - a year per row, the latest three.

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

SELECT d::date AS day, (random() * 20)::int AS visits FROM generate_series(date '2026-01-01', date '2026-12-31', interval '1 day') AS d

Scatter and bubbles

Points placed by two numbers. With Size, bubbles; with Group, a series per group.

Each technician's orders against hours worked this month, a series per branch: choose branch for Group.

SELECT u.name AS technician,
       count(DISTINCT te.work_order) AS orders,
       round(sum(te.minutes) / 60.0, 1) AS hours,
       b.code AS branch
FROM time_entries te
JOIN technicians t ON t.id = te.technician
JOIN totalbase.users u ON u.id = t."user"
JOIN branches b ON b.id = t.branch
WHERE te.started_at >= date_trunc('month', now())
GROUP BY u.name, b.code

SCATTER

Points by two numbers - with Size, bubbles; with Group, a series per group.

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

SELECT * FROM (VALUES ('Ana', 12, 3500, 42000, 'GOLD'), ('Luis', 30, 2100, 63000, 'BLACK'), ('Marta', 7, 5200, 36400, 'GOLD'), ('Pedro', 18, 2900, 52200, 'PLATINUM')) AS t(customer, visits, avg_ticket, spent, level)

Next steps

• Maps: points on a street map.
• Editing a Widget: choosing a role's column by hand.