transformations:runningtotal
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:runningtotal [2016/09/20 23:07] – dmitry | transformations:runningtotal [2019/04/16 13:30] – dmitry | ||
---|---|---|---|
Line 21: | Line 21: | ||
**Transformation parameters: | **Transformation parameters: | ||
- | * Mode: Rank | + | * Mode: Rank descending |
* Group by: Continent | * Group by: Continent | ||
Line 34: | Line 34: | ||
| Ob | 5410 | Asia | 4| | | Ob | 5410 | Asia | 4| | ||
| Paraná | | Paraná | ||
+ | |||
+ | **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. | ||
+ | |||
+ | // |
transformations/runningtotal.txt · Last modified: 2022/10/02 20:14 by craigt