Version 2021

Create Transformations

Transformations allow you to apply an attribute-element based offset to compare metric data.

Metrics use time transformations to compare values at different times, such as this year versus last year or current date versus month-to-date. For example, the Last Year transformation maps each time period to its corresponding time period last year, while the Month-to-Date transformation maps each time period to a set of time periods that comprise the entire month to date.

While transformations are most often used for discovering and analyzing time-based trends in your data, not all transformations have to be time-based. For example, a transformation can map defunct product codes to new ones. An example of a non-time-based transformation is This Catalog/Last Catalog, which might subtract a number from an old product code to convert it into a new one.

Check out the video below to learn more!

  1. Open the Workstation window.
  2. In the Navigation pane, click , next to Objects.

  3. Select the environment and project where you want to save your transformation.

  4. Click Transformation and Select.

  5. To add an expression, click New Expression.

  6. To delete an expression, right-click it and choose Delete. You can multi-select expressions for deletion.

  7. Click Save.