User Tools

Site Tools


transformations:group

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
transformations:group [2016/06/19 23:09]
dmitry
transformations:group [2016/06/19 23:09] (current)
dmitry
Line 4: Line 4:
  
 ** Use cases ** ** 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,​ 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> ​+  * 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' ​using Group transformation, ​and then rewrite expressions using the flag:  <​code>​if([Flag]='​Yes',​ ...) </​code> ​
   * Group values for charts (e.g. changing insignificant dimension values to "​Other"​)   * 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.   * Calculating new values of a column only for particular values in another column, leaving the rest unchanged.
transformations/group.txt · Last modified: 2016/06/19 23:09 by dmitry