transformations:subtotal
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:subtotal [2021/05/05 10:47] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== TOTAL/ | ||
+ | Category: Transform / Math\\ | ||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action appends to a dataset a new column that contains an aggregated total for selected column, or subtotals for groups.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | Create a " | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |New column|Enter a name for the new total/ | ||
+ | |Target column|Select the numeric column used to generate the aggregate values.| | ||
+ | |Mode|Select the aggregation mode. Options: | ||
+ | |Groups|Select whether to derive the total/ | ||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | The new column will appear as the rightmost column in the dataset, by default. | ||
+ | |||
+ | The grouping aspect of the //Subtotal inside groups// option is case sensitive. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Example 1:** Add a column with Total Sales.\\ | ||
+ | |||
+ | **Source table:** | ||
+ | ^ Region ^ Sales ^ | ||
+ | | North | 100 | | ||
+ | | East | ||
+ | | North | 150 | | ||
+ | | East | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > New column is "Total Sales" | ||
+ | > Target column is " | ||
+ | > Mode is " | ||
+ | > Groups is " | ||
+ | \\ | ||
+ | **Result:** | ||
+ | ^ Region ^ Sales ^ Total Sales ^ | ||
+ | | North | 100 | 575 | | ||
+ | | East | ||
+ | | North | 150 | 575 | | ||
+ | | East | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | **Example 2:** Add a column with Total By Region.\\ | ||
+ | |||
+ | **Source table:** | ||
+ | ^ Region ^ Sales ^ | ||
+ | | North | 100 | | ||
+ | | East | ||
+ | | North | 150 | | ||
+ | | East | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > New column is "Total by Region" | ||
+ | > Target column is " | ||
+ | > Mode is " | ||
+ | > Groups is " | ||
+ | \\ | ||
+ | **Result:** | ||
+ | ^ Region ^ Sales ^ Total By Region ^ | ||
+ | | North | 100 | 250 | | ||
+ | | East | ||
+ | | North | 150 | 250 | | ||
+ | | East | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: |
transformations/subtotal.txt · Last modified: 2022/10/02 20:15 by craigt