Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Difference in totals when segmenting a custom metric

Avatar

Level 1

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?

1 Accepted Solution

Avatar

Correct answer by
Level 6

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  

View solution in original post

1 Reply

Avatar

Correct answer by
Level 6

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