transformations:group
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:group [2016/06/19 19:09] – dmitry | transformations:group [2021/09/13 22:46] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Group ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | Replace multiple values with a single value (constant or calculated). | + | \\ |
+ | =====Description===== | ||
+ | Replace multiple values with a single value (constant or calculated). | ||
- | ** Use cases ** | + | \\ |
- | * Creating flags that can later be used in expressions. In this case the flag will designate a group (set), therefore verifying if a value belongs to the group can be done by checking the flag. For instance, instead of expressions with multiple comparisons, | + | =====Use cases===== |
+ | * Creating flags that can later be used in expressions. In this case the flag will designate a group (set), therefore verifying if a value belongs to the group can be done by checking the flag. For instance, instead of expressions with multiple comparisons, | ||
* Group values for charts (e.g. changing insignificant dimension values to " | * Group values for charts (e.g. changing insignificant dimension values to " | ||
* Calculating new values of a column only for particular values in another column, leaving the rest unchanged. | * Calculating new values of a column only for particular values in another column, leaving the rest unchanged. | ||
+ | * Create secondary demographic sets, combining specified values into rollup groups. | ||
- | ** See also ** | + | \\ |
- | * [[syntax: | + | =====Action settings===== |
- | * [[syntax: | + | ^Setting^Description^ |
+ | |Create/ | ||
+ | |Group (flag) as< | ||
+ | |Lookup column|Select the column with the values to be grouped. | ||
+ | |Grouping|Choose whether the selected values will be replaced with the group (flag) value, or whether all values // | ||
+ | |Value selection|Select the values to be replaced, or excluded from replacement, | ||
+ | <sup>*</ | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | Values that are not converted to the group (flag) value retain their original value. | ||
+ | |||
+ | This action replaces whole, selected values within the //Lookup column//, and does not work on partial matches.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | (coming soon) | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[syntax: | ||
+ | * [[syntax: |
transformations/group.txt · Last modified: 2021/09/13 22:46 by craigt