Supported summary functions

The SCT supports the following functions for timestep aggregations.

Note: For the arithmetic functions, undefined values (NaNs) are ignored.

• 1st—displays the first value in the aggregation interval.

• Ave—displays the average of all timesteps in the aggregation interval.

• Divider—displays a thin visual divider, which can have a user-defined background color.

• Last—displays the last value in the aggregation interval.

• Max—displays the maximum value in the aggregation interval.

• Med—displays the median value in the aggregation interval. Since computing the median requires the timestep values to be sorted, this can slow the speed of SCT refreshes. If there is an even number of non-NaN values, the median is defined as the mean of the middle two values.

• Min—displays the minimum value in the aggregation interval.

• Difference—displays the difference of the values in the previous two intervals. Available for custom summary rows only.

• None—does not perform an aggregation; the summary cell for each aggregation interval is blank.

• Nth (particular n; for example, 5th)—displays the nth value in the aggregation interval.

• Slot Reference—available for custom summary rows only. Displays the last value in a referenced slot. A value is displayed only if the referenced slot uses the same units as the current slot.

• Sum—displays the sum of all values in the aggregation interval.

Related topics

Revised: 07/05/2022