Pivot Tables
Agents down the side, weeks across the top, and the number you care about in every cell. Totals on both edges, a grand total in the corner, and headers that stay put as you scroll. It is the shape finance asks for when a chart will not settle the argument.
Postgres groups, JavaScript arranges
6 of 9 triples placed| row_label | col_label | value |
|---|---|---|
| Enterprise | 2025-Q3 | 412K |
| Growth | 2025-Q3 | 186K |
| Starter | 2025-Q3 | 41K |
| Enterprise | 2025-Q4 | 508K |
| Growth | 2025-Q4 | 204K |
| Enterprise | 2026-Q1 | 473K |
| Starter | 2026-Q1 | 52K |
| Enterprise | 2026-Q2 | 561K |
| Growth | 2026-Q2 | 231K |
| tier \ quarter | 2025-Q3 | 2025-Q4 | 2026-Q1 | 2026-Q2 |
|---|---|---|---|---|
| Enterprise | 412K | 508K | 473K | · |
| Growth | 186K | 204K | · | · |
| Starter | 41K | · | 52K | · |
A hundred and fifty label pairs by default, three thousand at the ceiling. Past that the grid is trimmed rather than paged.
The cell holds the widget's primary measure. One dimension down and one across is the shape; arrays of either are not accepted on the config.
The drawer's Visualization tab opens on the table shape, so crossing two dimensions is a pair of pickers rather than a definition written by hand. The runtime decides on the presence of a pivot config and the renderer draws it with sticky headers on both edges. Color rules land per cell through the same evaluator the charts use.
Product figures from the platform’s own defaults - not customer averages
How it works.
Counted once, arranged afterward
One pass counts both dimensions at once and comes back with a row label, a column label and a value. Those get sorted onto the two edges and dropped into place. A pairing nothing came back for stays empty rather than reading zero, because none and zero are different answers.
Both edges band the same way a chart does
Each dimension takes the same banding a chart dimension does, so quarters can run across the top while product bands run down the side. The query orders both axes by their bucket keys and the runtime then re-sorts the labels as plain strings, which is why dated bands read correctly and numeric ones come out in alphabetical order.
Totals cover the window you are looking at
Switching them on sums the matrix in memory. That means they total the window that came back, which is the same window you are looking at, and not a separate pass over the whole table.
Two pickers, not a definition to hand-write
A tile becomes a grid the moment it carries a pivot setting, and it is drawn with sticky headers on both edges. The drawer's Visualization tab opens on the table shape, so crossing two dimensions is a pair of pickers rather than a definition somebody has to hand-write.
Two moments in every number.
Every number passes through the same seven. Pivot Tables is the lit ones, and everything either side of it is a different page in this category.
- 01Query
what is asked, and of what
- 02Shape
the measure and the dimension
- 03Draw
the visual chosen for that shape
- 04Arrange
where it sits on a dashboard
- 05Filter
narrowing it after the fact
- 06Drill
going from the number to the rows
- 07Share
who else gets to see it
The specifics.
8 facts- Dimensions
- Exactly one down and one across. An array on either axis is refused by the config rather than flattened
- Cell value
- The widget's primary measure. A second measure per cell is not supported
- Budget
- A hundred and fifty label pairs by default, three thousand at the ceiling. Past that the grid is trimmed, not paged
- Empty cell
- Drawn as a dash so an absent combination reads differently from a zero
- Totals
- Two switches, one per edge, computed over the returned window. The corner is derived rather than switched, and it is only painted inside the column-totals row
- Color rules
- Applied per cell by the same evaluator the charts use, so a coordinate under target reads like a bar under target
- Authoring
- The drawer's Visualization tab on the table shape, or an import of a definition written elsewhere
- Not the same as
- Chart Visuals, where this is one of two names the table shape offers
What this is assembled from.
A number on a dashboard was built somewhere before it was drawn. These are the parts it is made of.
More in Reporting & Analytics
12 capabilitiesSeven data shapes, twenty-two visuals, shareable without a login.
Hand a board to a team or a CRM role, at read or at edit, by the person who built it. Roles outlive people, which is why a share points at one, not a mailbox.
The board a team opens on holds the figures that team is judged by, not everybody's. Six columns to lay them out in, and your own tab opens first.
Click the bar for one queue and the rest of the board goes with it. The next question gets asked by pointing at the answer, and undone by clicking again.
Some answers will not fit on the board that raised the question. A click leaves carrying the value it stood on, and lands on a board already narrowed to it.
A board on the wall gets read from across the room. Anything under target colors itself as the chart is painted, so a supervisor sees it without stopping.
The number that was promised, drawn across the same chart as the number that arrived, so the floor reads itself against its target, not yesterday's bars.
Nobody has to remember what last week looked like, or dig out the sheet it was written on. The same figure is counted again over the window before it.
The report that needs two exceptions and a date range stays one widget, instead of three tiles that nearly agree. Seventeen operators in a nested and-or tree.
Six palettes, one a print set for the pack that goes in front of a client. Pin one to a tile and the series, axis, grid and tooltip all move together.
Send a client the board without giving them a login. The address works until the day you name, dies the moment you revoke it, and leaves a row explaining why.
A figure on the screen where the work happens, not on a board somebody must remember to open. Built once, worked out against the records of whoever opens it.
How many calls, how many answered, how long they ran, how many missed, counted off the records the switch already wrote. Not a sample or last night's export.
The rest of the platform.
Five more categories, all on the same record and the same bill. Each card names three of its capabilities, so you can tell from here whether it is worth opening.
Reporting & Analytics
See pivot tables on your own floor.
Thirty minutes, your numbers and your data. We will set pivot tables up live and you can decide from the thing itself rather than from this page.
14-day trial · no card · migration included