Replace metrics

When you replace metrics, consider the following guidelines:

  • Only 1:1 substitutions are allowed. 1:many or many:1 are not allowed.

  • If the selected metric is not present in one of the selected requests, the request is left unchanged.

  • The new metric is placed in the same location as the substituted metric.

    • In a Pivot Layout, if a pivot layout request outputs date, visit, visitors, daily unique and visitors is replaced by revenue, the updated request layout will be: date, visit, revenue, and daily unique.
    • In a Custom Layout, if the visitors metric was output in cell F11, the updated request layout will show revenue in the same cell F11.
  • If the substituted metric had some operation applied to it (average, pre-pended text, post-pended text, microcharting), these operations will also be applied to the new metric.

To replace a metric

  1. Select one or more requests in Excel and right-click to select Edit Metrics. Alternatively, you can click Manage > Edit Multiple > <choose metric> > Edit Group to select the group of requests to modify.

  2. Select Replace Metric.

    Screenshot of the Edit Group screen with Replace Metric selected.

  3. Select the metric you want to replace and the replacement metric.

  4. Refresh the request. Offline data is shown until you refresh the data.