Differences

This shows you the differences between two versions of the page.

--- transformations:runningtotal [2018/06/07 09:58] – dmitry
+++ transformations:runningtotal [2019/04/16 13:32] – dmitry
@@ Line 34: / Line 34: @@
 | Ob  |  5410  |  Asia  |  4|
 | Paraná  |  4880  |  South America  |  2|
+**Ranking modes**
+Note that ranking can be done in one of two modes that return different results in cases when some column values occur more than once:
+//Dense ranking// - In dense ranking, items that compare equally receive the same ranking number, and the next item(s) receive the immediately following ranking number. E.g. 1,2,2,2,3.
+//Competition ranking// - In competition ranking, items that compare equal receive the same ranking number, and then a gap is left in the ranking numbers. The number of ranking numbers that are left out in this gap is one less than the number of items that compared equal.  E.g. 1,2,2,2,5.
+The ranking mode can be specified in the action settings.