User Tools

Site Tools


This is an old revision of the document!


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, e.g.
    if([x]='A' or [x]='B' or [x]='C' ...) 

    it can be more convenient to flag A, B, C,.. with 'Yes' and then rewrite expressions using the flag:

    if([Flag]='Yes', ...) 
  • 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.

See also

transformations/group.1466377741.txt.gz · Last modified: 2016/06/19 23:09 by dmitry