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
-
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. -
Select Replace Metric.
-
Select the metric you want to replace and the replacement metric.
-
Refresh the request. Offline data is shown until you refresh the data.