Differences

This shows you the differences between two versions of the page.

--- transformations:group [2016/06/19 19:01] – created dmitry
+++ transformations:group [2016/06/19 19:09] – dmitry
@@ Line 4: / Line 4: @@
 ** 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.
+  * 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, e.g. <code>if([x]='A' or [x]='B' or [x]='C' ...) </code> it can be more convenient to flag A, B, C,.. with 'Yes' and then rewrite expressions using the flag:  <code>if([Flag]='Yes', ...) </code>
   * Group values for charts (e.g. changing insignificant dimension values to "Other")
   * Calculating new values of a column only for particular values in another column, leaving the rest unchanged.