Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!

Wrong column sum/total on a freeform

Avatar

Level 2

Hello,

I recently discovered something weird. My total column is wrong. When I do an extract in csv and sum all my lines I have the right total amount but in my freeform the total is quite different.

As you can see in the screenshot attached, I have an Annual Pass total of booking of 2687 when I should have 2774... This is even weirder when the revenue total is right.

1827207_pastedImage_0.png

Is anyone has an idea on how I can I resolve this ?

Kind regards,

Aymane

5 Replies

Avatar

Level 10

Hi Aymane,

Could you explain where 2774 comes from. Is it the number you can see in another report/ table? If yes, can you please share a screenshot?

Hello Andrey,

Thank you for your quick answer !

Indeed I should give more details.

The 3 numbers highlighted in yellow are supposed to be equals (2774). You can see there is absolutely the same amount of lines (47) and the revenue is the same. (of course the product selected are the same and so are the time period).

1827251_pastedImage_0.png

As I said in my first message, when I extract those 2 freeform, and I sum all the 47 respective lines, I have the same right amount of bookings (2774).

My question is : why does the first freeform isn't giving me the right sum ?

It is the first time ever that something like that happens to me.

Thank you for your time,

Aymane

Avatar

Level 10

Aymane, I presume you see a higher number in the right table because not all 2774 Bookings are linked to Annual Pass value, there may be bookings related to the other Annual Pass dimensions values.

To check that consider one of the following:

1) add another Booking column to the right table, then add Annual Pass dimension value under it as a filter. Then compare Bookings and Filtered Bookings values line by line

2) break down all 47 lines in the right table by Annual Pass dimension

3) create a segment from 47 values, add it to the table as a dimension, break it down by Annual Pass dimensions

Avatar

Community Advisor

Do you have 1 to 1 relatioship between Annual Pass and Component inventory ?

It could be that the line 2 Annual pass has the deduplicated value and the break down has the non deduplicated value if the relatioshiop is 1 to N.

Is Bookings an event or the default orders metric ?

What are the dimentions that you are using ? eVars ? props ? classification ?

Avatar

Level 2

Hello Andrey Osadchuk​ and Alexis Cazes,

Thanks for your answers and advices. I have find the solution to my problem.

It is just that Adobe deduplicated the amount of booking...

Thanks,

Aymane