Cumulative, Group, Moving and Remaining Minimum are supported within the Windowed Minimum function. This function derives a new column containing the minimum value of a column or expression. When one or more Partition Columns are specified, the minimum values are determined over the rows in each partition. Any of the Rows options may be used with this function. When dragging a Windowed Minimum function into a variable, the following tree element is created.
Sort expressions can be built up in the Sort Expressions folder, Partition Columns can be built up in that folder. The options to perform a Cumulative, Group, Moving or Remaining Minimum, and their associated options are enabled through the Properties panel. Double-click on Windowed Minimum, or highlight it and click Properties.
-
Aggregation Style — CumulativeSecond Row Style
- None, or
- Current Row, or
- Value Preceding, or
- Value Following.
(If Value Preceding/Following)
Second Value — 0-n
- Aggregation Style — Group
-
Aggregation Style — MovingFirst Row Style
- Current Row, or
- Value Preceding, or
- Value Following.
(If Value Preceding/Following)
First Value — 0-n
Second Row Style
- None, or
- Current Row, or
- Value Preceding, or
- Value Following.
(If Value Preceding/Following)
Second Value — 0-n
-
Aggregation Style — RemainingFirst Row Style
- Current Row, or
- Value Preceding, or
- Value Following.
(If Value Preceding/Following)
First Value — 0-n