Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

*This article is an addition to the documentation on Using Table Calculations.

As of version 6.2, you can now access column totals on table calculations. To do this:

  1. Create a new look, or access any existing report that contains table calculations
  2. Click Explore from Here to edit
  3. Click the Totals checkbox to enable column totals*
    *This will enable totals on all columns (measures and table calculations)
    Image Added
    • The totals for every column will now be displayed.

Image Added A Note on how totals are calculated:
When the total for a calculation is a percentage (average), it will be calculated from the sum totals of the columns used in the calculation, rather than an average of the values in the calculation column.

For example- in the above image, the table calculation Missed Rate (35%) is not obtained by averaging the displayed values in the green column
Image Added

But by the totals of the 2 measures that make up the calculation:
Image Added
*To view the calculation, click the Calculations button

Image Added

In this case, the total for the table calculation of Missed calls is the value of Missed Calls (12,737)/ the value of Calls (36,156):
Image Added

for a total of .3522 (35%)