cumMax and cumMin functions
The cumMax and cumMin functions are very similar, as they calculate the values in the same way, but return opposite ones.
The cumMax function returns the cumulative maximum of the column, which is the greatest value between the current value of the column and the previous values of the same column, evaluated within groups defined by the group parameter if required.
The cumMin function returns the cumulative minimum of the column, which is the lowest value between the current value of the column and the previous values of the same column, evaluated within groups defined by the group parameter if required.
These functions divide the column into rows and compares the values one by one: this means that, if our column is made up of 10 records, the functions will compare row 1, then row 1 and 2, then row 1; 2; 3, then row 1; 2; 3; 4, and so on.
Function and parameters
cumMax(column, group)
cumMin(column, group)
Parameter | Description |
---|---|
column | It identifies the column to which you want to apply the formula. The column parameter is mandatory. |
group | It allows you to group the results by a certain column. |
Example - cumMax
The following example uses the Bike sales dataset.
Description | Screenshot |
---|---|
In the example here, we want to fill the cumMax attribute with the cumulative maximum of the Order_Quantity attribute. The formula to write is: | |
|
Example - cumMin
The following example uses the Bike sales dataset.
Description | Screenshot |
---|---|
| |
|