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

Difference in totals when segmenting a custom metric

Avatar

Avatar
Level 1
Francis_Lemin
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Francis_Lemin
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
Francis_Lemin
Level 1

10-07-2020

I'm looking at some data for a particular page in my journey YTD, so there is a calculated metric to provide figures for unique visits to that page month by month.

 

However when i duplicate the table and break it down further by a custom segments to split this figure between age ranges for some reason the total of all the new columns is more than the original.

I know there is some data that falls outside the age ranges i have asked for and even some showing as unspecified, but these would surely add even more to this new total.

 

francisl1897100_0-1594394653226.png

The totals of the table on the right are 21732 compared to the original(base) figure of 21159

 

Any idea what is happening?

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct Reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct Reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile
kainth
Level 4

13-07-2020

Hi @Francis_Lemin ,

Totals is generally calculated at the server-side & our server-side logic dedupes the duplicate value. For example, if a visitor starts his journey at 11:45 PM & continues to browse the web site until 12:10 AM then you if will see one Visit against each line item if you try to look at hourly visits report but the total will show Visit as 1 for this scenario as the same Visit persisted from the previous day.

As you mentioned that when you try to apply the segment below the calculated metric then the total is not matching. So, think this is happening because there will be some segment that contains the duplicate data.

Can you please share the segment definition that you are using along with the calculated metric?

Regards,

Abhinav