Average time spent on site for person ID dimension does not tally with the average time spent on site for form ID dimension | Community
Skip to main content
S
Serene2
New Participant
May 5, 2025
Solved

Average time spent on site for person ID dimension does not tally with the average time spent on site for form ID dimension

  • May 5, 2025
  • 1 reply
  • 371 views

Hi, i need some help. Can someone help to explain why the average time spent on site for person ID dimension (i.e. 36 seconds) does not tally with the average time spent on site for form ID dimension (40 seconds)? These individuals under the person ID have visited form 1. 

 

Form ID dimensionAverage time spent on site (seconds)
1. Form 140
 

Person ID dimension

(total 1,553 records)

36
1. Person A 362
2. Person B332
3. Person C334

.

.

.

.

.

.

Best answer by Jennifer_Dungan

It looks to me like there may be instances of "Form 1" that don't have a Person ID dimension.. so the average is calculating "Person A, Person B, Person C.... and Unspecified"..... but in the breakdown, you are only showing Person A, Person B, Person C...  (unspecified isn't being accounted for), hence the slight difference in the average

1 reply

Jennifer_Dungan
Jennifer_DunganAccepted solution
New Participant
May 6, 2025

It looks to me like there may be instances of "Form 1" that don't have a Person ID dimension.. so the average is calculating "Person A, Person B, Person C.... and Unspecified"..... but in the breakdown, you are only showing Person A, Person B, Person C...  (unspecified isn't being accounted for), hence the slight difference in the average

    Terms & ConditionsAccessibility statement

    Loading footer...