Formula is incorrect when calculated metrics is created from Workspace

Description description

Environment

  • Analytics
  • Customer Journey Analytics

Issue/Symptoms

Calculated metrics can also be created by selecting metrics from the Workspace freeform table. User can select the set of metrics then right click and then select Create Metrics.

Sometimes, the formula of the calculated metrics created is incorrect. For example, if Page Views and Visits  are selected (in that order), the formula shows as Visits/Page Views.

Resolution resolution

The formula of the calculated metric depends on the order, how a metrics is placed on the freeform table and not in the order they are selected. For example, if order of the metrics in the freeform table is Orders and then Page Views, formula will be Orders / Page Views /, and if the metrics is placed as Page Views and then Orders, the formula will be Page Views / Orders.

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f