How do totals for table calcs work?

Looker Tips & Resources Technical Tips & Tricks
1

Knowledge Drop

Last tested: Sep 21, 2020

Totals for table calcs work by apply the table calc logic to the totals of the measures that are referenced in said table calc.

In other words,

  1. For any fields referenced in the calculation, the totals are computed. (This will fail for dimensions because they are not included in the totals query.)
  2. The calculation is applied to the totals computed in step 1.

For example, if we had a table calc that is ${measure1} + $[measure2} . The total of this table calc is ${measure1:total} + ${measure2:total} , rather than computing ${measure1} + $[measure2} for each row and then totaling them somehow.