Transformations

No PostgreSQL specific customizations were made for this feature.

A transformation is a schema object that typically maps a specific time period to another time period, applying an offset value, such as current month minus one month.

Usually defined by a project designer, transformations are used in the definition of a metric to alter the behavior of that metric. Such metric is referred to as a transformation metric. For example, time-related transformations are commonly used in metrics to compare values at different times, such as this year versus last year or current date versus month-to-date. Any transformation can be included as part of the definition of a metric and multiple transformations can be applied to the same metric.

Example

The result based on the transformation metric returns results such as:

You can also self-define a transformation with the date and time functions:

Using the fact table as the relationship table (member table) can cause a self join to occur.

See the Project Design Help for more information about transformations. .