Lattice Grid Buy a licence

demo D317

A tile totalling rows the grid never loaded: JavaScript Data Grid Demo

A KPI panel beside a grid holding one page of a hundred thousand rows: the sum and average tiles ask the engine for the whole matching set rather than only the page, and say so

createKPI(el, { grid, tiles }) · computed: 'engine'

This totals a column across every matching row in a paged DuckDB source, not just the page the grid has loaded, and the tile says the engine computed it. It shows a KPI that stays true to the whole relation while the grid holds only a screenful.

Building…
Loading a live grid…

A tile totalling rows the grid never loaded

Each tile runs one aggregate through the same adapter the grid uses, with the grid’s filters applied, so the figure and the rows always agree.

Related demos

  • A panel of stat tiles · The same feed as a row of live figures beside a grid: a total, an average against a baseline, a count with good, warn and critical bands, and a sparkline, moving as data flows
  • A hundred thousand rows in DuckDB, no server · DuckDB reads a Parquet file in the browser and the whole set is pulled in, so the plant subtotals and the grand total are computed over all 100,000 rows
  • Spatial filtering pushed into DuckDB from a GeoParquet file · A small GeoParquet file of country locations, read by DuckDB’s spatial extension in the browser; drawing a box on the map pushes a within-the-box filter into the engine, and lastPlan shows the generated SQL