Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Average time on site = Infinity

madhurc30892467
Level 3
Level 3

Hi,

Although I see similar questions have been asked by different users before, but still I'm not able to find a satisfactory answer and I'm not sure if it's a bug specific to workspace analysis?

If I just want to see an overall view of avg.time spent on site, I see 'infinity' but if I break it down by months or some other dimension then I can the values being populated. However, it's also not the case, when we apply segment. Let me share with few screengrabs.

Overall along with segments:-

1622534_pastedImage_0.png

Monthly breakdown:-

1622535_pastedImage_1.png

Can you anyone help me here?

Thanks!

Madhur

1 Accepted Solution
ursboller
Correct answer by
Community Advisor
Community Advisor

per definition, the "time spent" metrics are calculated against a dimension! since bothe time ranges (first table) and segments (second table) are not dimensions, it can't find any visits with that dimension (since there is no dimension) so any average is divided by 0 (equals infinity).

from a technical view I believe that the data request wants to check at a hit-level where a certain dimension exists. and since both "date ranges" and "segments" are no dimensions, the request will fail or return 0.

link to help page: Time Spent

i hope some of the adobe pros can confirm, maybe Gigazelle​ or ericmatisoff​?

View solution in original post

4 Replies
ursboller
Correct answer by
Community Advisor
Community Advisor

per definition, the "time spent" metrics are calculated against a dimension! since bothe time ranges (first table) and segments (second table) are not dimensions, it can't find any visits with that dimension (since there is no dimension) so any average is divided by 0 (equals infinity).

from a technical view I believe that the data request wants to check at a hit-level where a certain dimension exists. and since both "date ranges" and "segments" are no dimensions, the request will fail or return 0.

link to help page: Time Spent

i hope some of the adobe pros can confirm, maybe Gigazelle​ or ericmatisoff​?

View solution in original post

Gigazelle
Employee
Employee

Yes, Infinity is Workspace's version of #DIV/0! which was seen in prior versions of Adobe Analytics.

When you use other dimensions instead of segments/dates, do you also see infinity?

madhurc30892467
Level 3
Level 3

Thank you, this is helpful. Is it only in workspace that it shows infinity as when we run the same in Report builder, then it doesn't show infinity.

Gigazelle
Employee
Employee

It should be pretty easily tested, but I believe it returns #DIV/0! in Report Builder.