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
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
  • 375 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

.

.

.

.

.

.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
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...