Virtual fields
Get an exact related value
Replace a count or total that covers only the first related items with the exact value, for one cell, one viewer, or every row of a field.
A collection column over a query link reads only the first related items of each row, as many as the link reads per row. When a row has more, its value carries a mark: 25+ on a count, + after chips, and ≥ or ~ before an aggregate. Use one of these ways to read the rest.
Compute Exact for one cell
- Right-click the marked cell and choose Compute Exact. You can also click the Σ button that shows at the cell’s edge on hover, or focus the cell and press
⌘ Enter(Ctrl + Enteron Windows and Linux). - Wait for the read. Dynomatic reads the row’s query to the end and replaces the value with the exact one.


Compute Exact replaces only that cell. Other columns over the same link keep their marks. The exact value stays until the query runs again, from Run, a refresh, or an auto-refresh tick.
Read every value in the viewer
- Right-click a chips or sparkline cell and choose View Value.
- Click Read every value.
The viewer replaces the values with the full list when the read lands. View a whole value covers the rest of the viewer.
Compute every row exactly in an expression
To make a field exact on every row without a click, call $relatedAll with the link’s name in the field’s expression. Dynomatic reads each row’s query to the end before it computes the field.
$count($distinct($relatedAll("passes").satelliteId))
OrbitGroundStations uses this expression for Satellites served. $count($relatedAll("passes")) equals the count that Compute Exact gives.
Every row now reads all of its related items, so the field costs more reads than a collection column does. Why related values can be partial weighs that cost.
When a row has too many items
Every one of these reads stops at 1,000 related items or 16 MiB of items for one row. Past that, the cell shows an error rather than a value over part of the items. $relatedAll reports it as Link passes has more than 1,000 items for this row, and a read of all of them stops at 1,000. To see every item of such a row, use Open all in new tab, which runs the query in the query builder.
Last updated on