Lattice Grid

The grid (rendering) ยท console.warn

createStat: the "{title}" tile's {fn} cannot...

Printed by The grid (rendering), prefixed [lattice], since 1.114.0.

Warnings reference › stat.aggregate-unavailable:*:*

Identifier
stat.aggregate-unavailable:*:*
Raised by
The grid (rendering)
Since
1.114.0

What happened

A sum/avg/min/max tile over a grid that holds only a window of its matching set (a pushdown, paged or remote source) cannot reduce the loaded rows - that would describe the page, not the relation. The engine could not answer it either, for the reason named, so the tile shows the documented unavailable state instead of a page-scoped figure.

The fix

Declare the statistic in the pushdown source's aggregates config (or the adapter's own capabilities.aggregates) so the engine can compute it, or scope the tile to selected rows if a window-scoped figure is what you actually want.

The smallest fix

createStat({ grid, container, title: 'Total', of: 'amount', fn: 'sum' });

Reference

Covered in full at the API reference.