DocumentationCustomer Journey AnalyticsCustomer Journey Analytics Guide

Workspace totals workspace-totals

Last update: Wed Sep 25 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

In Freeform tables, a total row appears at each breakdown level and can show two totals:

Freeform Table highlighting the grand total and the table total.

  • Table total ➊ - This total is typically equal to or a subset of the Grand total. The total reflects any table filters applied within the freeform table, including the Include None option.
  • Grand total (out of number) ➋ - This total represents all events that have been collected. When a filter is applied either at the panel level or within the freeform table, this total adjusts to reflect all events that match the filter criteria.

Display totals

Under Setting Column settings, there are options to Show totals and Show grand total. If these settings are unchecked, totals are removed from the table, which may be desired in cases where totals don’t make sense. For instance, in certain Calculated Metric scenarios.

Static row totals behave differently, and are controlled using Setting Row Settings.

Option
Description
Show sum of current rows as the total
Show a client-side sum of the rows in the table. This total does not de-duplicate metrics like sessions or persons.
Show grand total
Show a server-side sum. This total de-duplicate metrics like sessions or persons.

See Dynamic vs static dimension items in freeform tables.

Frequently asked questions

Questions
Answer
Which total are the gray column percentages based on?

This total depends on the Percentages setting selection under Row Settings:

  • Calculate percentages by column - This setting is the default. Percentages are based on the Table total.
  • Calculate percentages by row - Percentages are based on the Grand total.
How does the Include “No value” setting impact totals?
If the Include “No value” setting is unchecked, the No value row is removed from the table, the Table total, and carries through to any calculated metrics that use Total metric types
When custom table filters are applied to a freeform table, do all of my calculated metrics and conditional formatting account for the filter?

Not currently. Include “No value” is account for, but custom table filters do not impact the following:

  • The column max / min range that conditional formatting uses looks across all data.
  • Calculated metrics that leverage Grand total metric types.
  • Calculated metrics with functions that calculate across rows in a freeform table: Column Sum, Column max, Column min, Count, Mean, Median, Percentile, Quartile, Row Count, Standard Deviation, Variance, Cumulative, Cumulative Average, Regression variants, T-Score, T-Test, Z-Score, and Z-Test.
In Calculated Metrics, what does the Grand total metric type reflect?
Grand total continues to refer to the Grand total, and does not reflect filters applied to a table or the Table total.
What total is shown when data is either copied and pasted from a freeform table or downloaded via CSV?
The total row reflects the Table total only and respects the column Show totals setting.
recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79