Solved

Overall total is less than the sum of the rows

  • 2 May 2023
  • 3 replies
  • 109 views

Badge

When I create a data table in Amplitude that looks at uniques page views, the Overall row is less than the sum of all the rows below. Surely these two should equal one another?

Please can you advise? Many thanks!

icon

Best answer by Saish Redkar 2 May 2023, 19:31

View original

3 replies

Userlevel 7
Badge +10

HI @B Analytics 

This is a common scenario if a group-by is added to the event in the left column.

The total sum for the event in the Overall row need not be the sum of each of the rows below. Since  there is a group-by applied to the event, the same user can exist in multiple rows for each of the group by values.

Hope this helps.

Userlevel 5
Badge +8

@Saish Redkar thank you!! @B Analytics keep us posted on how that works out for you! 

Badge

Thanks both! This makes sense - thank you for confirming!

Reply