Workspace totals
In Freeform tables, a total row appears at each breakdown level and can show two totals:
- Grand Total (gray ‘out of’ number) - this total represents all hits that have been collected, sometimes referred to as ‘report suite total’. When a segment is applied either at the panel level or within the freeform table, this total adjusts to reflect all hits that match the segment criteria.
- Table Total (black number) - this total is typically equal to or a subset of the Grand Total. It reflects any table filters applied within the freeform table, including the Include None option.
Display Total Setting display-total
Under Column Settings, there are options to Show Totals and Show Grand Total. If these settings are unchecked, totals will be removed from the table. This may be desired in cases where totals don’t make sense, for instance, in certain calculated metric scenarios.
Static Row Total settings static-row-total
Static row totals behave differently, and are controlled under Row Settings.
- Show sum of current rows as the total - this shows a client-side sum of the rows in the table which means the total will not de-duplicate metrics like visits or visitors.
- Show Grand Total - this shows a server-side sum, which means the total will de-duplicate metrics like visits or visitors.
Frequently asked questions
This depends on the Percentages setting selection under Row Settings:
- Calculate percentages by column - This is the default setting. Percentages will be based on the Table Total.
- Calculate percentages by row - Percentages will be based on the Grand Total.
Not currently. Include Unspecified (None) will be accounted for, but custom table filters will not impact the following:
- The column max/min range that conditional formatting uses will look across all data.
- Calculated metrics that leverage Grand Total metric types.
- Calculated metrics with functions that calculate across rows in a freeform table - i.e. 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, Z-Test.