The Edit Metrics Across Multiple Requests feature lets you easily add, remove, or replace metrics in a pre-existing request or across a group of requests.
Keep in mind that
To add one or more metrics:
Select one or more requests in Excel and right-click to select Edit Metrics. (Or, click Manage > Edit Multiple > <choose metric>
> Edit Group to select the group of requests to modify.)
Select **Add Metric(s)**and select the metrics to add.
Refresh the request to see actual data. Until you refresh, you will see offline data.
Keep in mind that
Only 1:1 substitutions are allowed, not 1:many or many:1.
If the metric selected to be replaced is not present in one of the selected requests, this request is left unchanged.
The new metric will be placed in the same location as the substituted metric. This means:
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. (Or, click Manage > Edit Multiple > <choose metric>
> Edit Group to select the group of requests to modify.)
Select Replace Metric.
Select which metric to replace and which metric to replace it with.
Refresh the request. Until you refresh, you will see offline data.
Keep in mind that
If any of the metrics selected to be removed are not present in one of the selected requests, this request is left unchanged.
In a Pivot Layout, removing a metric causes the layout to shift for metrics that are located after the removed metric.
Example: if a pivot layout request outputs date, visits, visitors, daily unique, and you remove “visits”, the updated layout for the request will show: date, visitors, daily unique.
To remove metrics:
Select one or more requests in Excel and right-click to select Edit Metrics. (Or, click Manage > Edit Multiple > <choose metric>
> Edit Group to select the group of requests to modify.)
Select Remove Metric(s).
Select one or more metrics to remove from the request.
Refresh the request. Until you refresh, you will see offline data.