When you view reports in the marketing reports and analytics capability, 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 [orders] / [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:
- Create a calculated metric that includes the Total versions of the metrics that you're looking to include.
- Create a Data Extract report, which can be scheduled.
- Create a data block within ReportBuilder.