How calculated metric totals are displayed differs between Reports & Analytics and Analysis Workspace. This section explains the differences.
When you view reports in Reports & Analytics, calculated metrics always display
n/a under the total. Since all calculated metrics are user-defined, there are many circumstances where this total doesn’t make sense. Consider the following example:
Your organization has created the calculated metric
visits to determine the percentage of visits that purchased something on your site. If you brought this metric into a products report, several products are attributed to a single order. And, several products are attributed to a single visit. If a calculated metric total was included in this report, the following questions arise:
|Does summing the line items make sense?||It doesn’t, since multiple products can be included in a single order, and multiple products can be included in a single visit. If the line items were aggregated, total orders and total visits would not match the actual total orders and total visits.|
|Does taking total orders and total visits make sense?||It doesn’t, as the total doesn’t match the sum of the individual line items. In addition, Total orders and Total visits are separately calculated metrics altogether.|
Since there’s no logical and concrete method to determine if a calculated metric makes sense in reporting, the metric total is omitted altogether. If you want to obtain a grand total, you can do one of the following:
When you view data in Analysis Workspace, calculated metric totals are displayed in most cases. In some cases, providing a total is not possible, such as when the rows of the report are of mixed format (e.g. decimal and currency).
When totals are displayed, they are often calculated server-side, which means that the total de-duplicates metrics like visits or visitors. Under certain circumstances, calculated metrics are generated client-side by summing across rows of the table, which means the total does not de-duplicate metrics like visits or visitors. This occurs:
For more information on totals in Analysis Workspace, visit Workspace totals.