Table view

A Table view lists readings as rows in time: every reading, or one row per time interval, with optional subtotal rows and a totals footer. Authors add it with Add table under Setup → Reports; viewers open it on the report page.

Settings

Setting	Field	Values	Default
Compact	compact	On or off. Denser padding and type.	Off
Max height	maxHeight	Pixels, 40–4000, or empty (null) for about one screen tall. The report page itself still scrolls.	Empty
Sticky column header	stickyColHeader	On or off. Keeps the parameter header row visible while scrolling.	On
Sticky row header	stickyRowHeader	On or off. Keeps the time column visible while scrolling sideways.	On
Show comments	showComments	On or off. Marks value cells that a comment covers.	Off
Row interval	rowCadenceMs	Each reading (precise), 1s, 1m, 5m, 15m, 30m, 1h, 4h, 1d	1m
Subtotals	subtotals	None (none), Per day (per-day), Per hour (per-hour)	None

Subtotals can be chosen with any Row interval. When each row already covers the subtotal period, for example 1d rows with Per day, the table shows no subtotal rows and the editor shows a hint.

Columns

Under Columns, Add columns from parameters lists every report parameter. The same parameter can be added more than once, for example with different totals. Columns are stored in parameters in display order; Move up and Move down reorder them.

Setting	Field	Applies to	Values	Default
Decimal places	decimalPlaces	Numeric	0–12	2
Value per interval	perCadenceValue	Numeric	First (first), Latest (latest), Average (average). Not used with Each reading.	Latest
Totals	totals	Numeric	None (none), Last (last), Delta (delta), Sum (sum), Average (average), Min (min), Max (max)	None
Zone background opacity	bgZoneColorOpacity	Numeric	0–1	0
Totals	totals	Integer, string	None (none), Last (last)	None
Background opacity for {value}	bgOpacity	Integer	0–1 for each integer value that has a value color on the report parameter, stored as { "<value>": <opacity> }	0 ({})

Integer and string cells show the latest value in each interval. Removing a report parameter that a table uses asks for confirmation and removes every column of that parameter.

On the report page

Rows

With Each reading, every stored reading in the window is a row. With an interval, each row is one completed interval: the interval that is still open is not shown. 4h rows are four consecutive hours aligned to whole hours, and 1d rows follow local midnight in the report timezone. Rows are the union of the timestamps of all columns. A column without a value at a row stays blank; earlier values are not carried forward. Hidden parameters are left out of the table.

Totals and subtotals

The footer shows the column Totals over the same completed period as the rows. Totals are calculated from the stored readings, not by adding up the displayed cells. Delta is the last value in the period minus the last value in the preceding period of the same length; when that preceding period has no readings, the first value in the period is used instead. The footer is hidden when every visible column has None, and it stays visible while scrolling.

Subtotal rows cover each local day or hour that fits in the window. A partial first day or hour counts only its completed part. Subtotal rows appear only for days or hours that have ended.

Display

The time column comes first, as YYYY-MM-DD HH:mm:ss in the report timezone; day subtotals show YYYY-MM-DD and hour subtotals YYYY-MM-DD HH:mm. Numeric columns are right-aligned with fixed digit widths, use . as the decimal separator and no thousands separators. Integer values show the text label recorded with the reading, in the current language, when there is one; otherwise the number. Strings show as stored. Column headers show the parameter icon when it has one.

Zone colors (numeric) and value colors (integer) fill the cell background at the column’s opacity. Text uses the parameter’s Default color, Bold, and Italic.

Comments, clicks, and errors

With Show comments on, value cells covered by a comment get a corner mark; hovering lists the comments. See comment markers. Clicking the table does not change the time window, and the table does not receive live values. Errors are shown inside the view.

Related

• Report settings
• Report page, including CSV export
• Chart, time bars, histogram, calendar, hourly matrix, state duration, Sankey
• Comments
• Readings API: readings.cadence, readings.raw, readings.aggregate (readings procedures)