Aggregate table

Displays aggregated values over medium-to-long time ranges in a customizable table. Cells can contain static text, variable aggregations, or formulas; headers, units, and decimal precision can also be defined.

It is useful for consumption and production summaries and comparisons between indicators.

Configuration

Data cells use variable selection, the time range, and an aggregation type. Headers, matrix structure, and cell types are specific to the table.

Specific settings

1. For each column, enter the header text and choose whether its values can be sorted; the trash button removes the column.
2. Add column inserts a new column into the table.
3. Kind of cell defines the individual cell's content: Static, Aggregate, or Formula.
4. A static cell displays the value entered in Text.
5. An aggregate cell requires a variable, aggregation type, unit, and number of decimal places.
6. Each cell is independent and can use a different variable or aggregation from the other cells in the same row.
7. Add new row inserts a row; the trash button on its right removes it.

Formula cells calculate a result from aggregated values and allow a unit and decimal places to be set.