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 [2019/04/16 13:30] – dmitry | transformations:runningtotal [2021/07/17 23:46] – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Running total ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Math\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | EXAMPLE | + | \\ |
+ | =====Use cases===== | ||
+ | *Calculate a running total of sales by time period (weekly, monthly, or annually). | ||
+ | *Generate the order of completion in a timed event/ | ||
- | **Source table:** The longest rivers in the world | ||
- | ^ | + | \\ |
- | | Nile | + | =====Action settings===== |
- | | Amazon | + | ^Setting^Description^ |
- | | Yangtze | + | |New column|Enter a name for the new column.| |
- | | Mississippi | + | |Target column|Select the column used to generate the selected values.| |
- | | Yenisei | + | |Mode|Select the mode. Options: |
- | | Yellow River | 5464 | Asia | | + | |Groups|Select whether to derive the running values across all rows in the dataset, or grouped by selected columns.\\ |
- | | Ob | + | \\ |
- | | Paraná | + | ====Rank modes==== |
+ | ^Rank mode ^Description | ||
+ | |Dense ranking| In dense ranking, values that are equal receive the same ranking number, and the next item(s) receive the ranking\\ number immediately following. E.g. 1,2,2,2,3.| | ||
+ | |Competition ranking|In competition ranking, values that are equal receive the same ranking number, and 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\\ are equal. E.g. 1,2,2,2,5.| | ||
- | **Objective: | + | \\ |
+ | =====Remarks===== | ||
+ | The //Rank//, //Rank descending// | ||
- | **Transformation parameters:** | + | \\ |
+ | =====Examples===== | ||
+ | **Example:** Rank rivers on each continent by length.\\ | ||
- | * Mode: Rank descending | + | **Source |
- | * Group by: Continent | + | |
- | + | ||
- | **Output | + | |
- | ^ River ^ Length(km) | + | |
- | | Nile | 6650 | Africa | + | |
- | | Amazon | + | |
- | | Yangtze | + | |
- | | Mississippi | + | |
- | | Yenisei | + | |
- | | Yellow River | 5464 | Asia | 3| | + | |
- | | Ob | 5410 | Asia | 4| | + | |
- | | Paraná | + | |
- | **Ranking modes** | + | ^River |
+ | | Nile | 6650|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River| | ||
+ | | Ob | 5410|Asia | ||
+ | | Paraná | ||
+ | \\ | ||
+ | **Action parameters:** | ||
+ | > Mode is "Rank descending" | ||
+ | > Group by Continent | ||
+ | \\ | ||
+ | **Result table:** | ||
+ | ^River | ||
+ | |Nile | 6650|Africa | ||
+ | |Amazon | ||
+ | |Yangtze | ||
+ | |Mississippi | ||
+ | |Yenisei | ||
+ | |Yellow River | 5464|Asia | ||
+ | |Ob | 5410|Asia | ||
+ | |Paraná | ||
- | Note that ranking can be done in one of two modes that return different results | + | \\ |
+ | ====Community examples=== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
- | //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. | + | \\ |
+ | =====See also===== | ||
+ | * [[transformations: | ||
- | // |
transformations/runningtotal.txt · Last modified: 2022/10/02 20:14 by craigt