transformations:runningtotal
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:runningtotal [2016/09/20 23:07] – created dmitry | transformations:runningtotal [2019/04/16 13:30] – dmitry | ||
---|---|---|---|
Line 17: | Line 17: | ||
| Paraná | | Paraná | ||
- | **Objective: | + | **Objective: |
**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