Why don't my table totals match what I see in the rows?

Last updated: July 23, 2025

Column totals are calculated from all your underlying data, not just the visible rows in your table. This can create differences between the total and what you'd get by manually adding up the visible values.

Why totals might be lower

With count distinct metrics, the same item might appear in multiple rows but only gets counted once in the total.

Example: If you're counting distinct devices by month, one device might appear in January AND February. Adding the rows gives you 2, but the true distinct count is 1.

It would look something like this:

Why totals might be higher

Two possible reasons:

  1. Row limits: Your query results are truncated, but totals include all data

  2. Metric/table calculation filters: Totals are calculated before filters are applied

Want totals that match your visible data?

Create a table calculation using:

SUM(${my_table_name.my_metric_name}) OVER()

Note: This won't give you a "true" total for count_distinct metrics.