cumrank

cumrank(X, [ascending=true], [ignoreNA=true], [tiesMethod='min'], [percent=false])

Please see Cumulative Window Functions for the parameter description and windowing logic.

X is a vector/ matrix.

ascending (optional) is a Boolean value indicating whether to sort in ascending order. It is an optional parameter and the default value is true.

ignoreNA (optional) is a Boolean value indicating whether NULL values are ignored in ranking. True means ignoring the NULL value, and false means the NULL values participate in the calculation. The default value is true. If NULL values participate in the ranking, they are ranked the lowest.

tiesMethod (optional) is a string indicating how to rank the group of records with the same value (i.e., ties):

• 'min': lowest rank of the group

• 'max': highest rank of the group

• 'average': average rank of the group

percent (optional) is a Boolean value, indicating whether to display the returned rankings in percentile form. The default value is false.

If X is a vector, for each element in X, return the position ranking from the first element to the current element. The result is of the same length as X. If ignoreNA = true, NULL values return NULL.

If X is a matrix, conduct the aforementioned calculation within each column of X. The result is a matrix with the same shape as X.

cumrank(1 3 2 3 4);
// output
[0,1,1,2,4]

cumrank(1 3 2 2 4 NULL, , true);
// output
[0,1,1,1,4,]

cumrank(1 3 2 2 4 NULL, , false);
// output
[0,1,1,1,4,0]

cumrank(1 3 2 2 4 NULL, , false, 'max');
// output
[0,1,1,2,4,0]

m=matrix(1 4 2 3 4, 4 NULL 6 1 2);
m;

cumrank(m);

Related function: rank