Przejdź do głównej zawartości
Dokumentacja

Table view

Ta treść nie jest jeszcze dostępna w Twoim języku.

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

Section titled “Settings”
SettingFieldValuesDefault
CompactcompactOn or off. Denser padding and type.Off
Max heightmaxHeightPixels, 40–4000, or empty (null) for about one screen tall. The report page itself still scrolls.Empty
Sticky column headerstickyColHeaderOn or off. Keeps the parameter header row visible while scrolling.On
Sticky row headerstickyRowHeaderOn or off. Keeps the time column visible while scrolling sideways.On
Show commentsshowCommentsOn or off. Marks value cells that a comment covers.Off
Row intervalrowCadenceMsEach reading (precise), 1s, 1m, 5m, 15m, 30m, 1h, 4h, 1d1m
SubtotalssubtotalsNone (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

Section titled “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.

SettingFieldApplies toValuesDefault
Decimal placesdecimalPlacesNumeric0–122
Value per intervalperCadenceValueNumericFirst (first), Latest (latest), Average (average). Not used with Each reading.Latest
TotalstotalsNumericNone (none), Last (last), Delta (delta), Sum (sum), Average (average), Min (min), Max (max)None
Zone background opacitybgZoneColorOpacityNumeric0–10
TotalstotalsInteger, stringNone (none), Last (last)None
Background opacity for {value}bgOpacityInteger0–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

Section titled “On the report page”

Rows

Section titled “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

Section titled “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

Section titled “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

Section titled “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.

Section titled “Related”