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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.
SOLVED

Inaccurate Totals in Workspace Freeform Tables

Avatar

Level 4

Hello,

I am seeing an issue where the totals at the top of a workspace freeform table do not add up to the numbers that are displayed in the rows. I have attached two screenshots below:

Here you can see the freeform table and how it has been built in Workspace:

2018-09-20_14-55-05.png

The following image shows the data copied over to excel and you can see that the totals do not match the totals in Workspace:

2018-09-20_15-29-48.png

I would like to know why there is a difference between workspace and excel.

Thanks in advance.

1 Accepted Solution

Avatar

Correct answer by
Level 2

Hi

Visits are attributed to two different month rows when they cross the month border (midnight at the end of one month). In the 'total' row these visits are deduplicated as the other post describes.

View solution in original post

0 Replies

Avatar

Community Advisor

mravlich​, the numbers in TOTAL ROW look deduplicated. Click on the gear icon next to the "Departure Mo" dimension and toggle the radio button if you are looking for a SUM.

Avatar

Level 4

Hi Andrey,

I am not seeing the toggle you mention when I click on the gear icon:

gear-icon.png

Am I looking in the correct area?

Thanks.

Avatar

Correct answer by
Level 2

Hi

Visits are attributed to two different month rows when they cross the month border (midnight at the end of one month). In the 'total' row these visits are deduplicated as the other post describes.

Avatar

Employee Advisor

More info: Compare sum of line items to report total

Milco is 100% correct. Visits that span midnight of the month crossover are counted in both rows, but the total is deduplicated.

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now