Incorrect Unique Journey Entries sum count

[AGoodDoc]

Hi, 

I am trying to create a Adobe CJA report for the journeys matching a condition. Under the Unique Journey Entries metrics, I see the total count as being incorrect {Total displayed :15/15 | actual sum : 24}. Need help 

[Harveer_SinghGi1 · Accepted solution]

Hi @AGoodDoc ,

CJA shows deduplicated metric value as the column total, what this means is that if there were multiple values seen in the same journey of the dimension/field that you are using against a metric then on rows level you'll see that metric attributed against each of those values but in total it will be deduplicated and counted only once.

Let's take an example, if user visited a site and viewed home page and product page during the same session, the report run for pages with session metric will give 1 session credit to each home page and product page, which if you add will result as 2 but the total number of sessions is actually 1 only and that is what will show as column total, like below

I hope this helps.

Cheers!

[AshishKu21]

Hi @Harveer_SinghGi1 ,

Thanks! that makes sense. 

Is there a way by which I can reflect/calculate the actual sum while retaining the individual count for each row

[Harveer_SinghGi1]

Hi @AshishKu21 ,

If by actual sum you mean returning 24 instead of 15 in the example shared in question then you can use column sum function in a calculated metric to return this information,

Please note that this metric will show column sum for each row when trended on a ranked report.

Cheers!

[AshishKu21]

Thanks @Harveer_SinghGi1