Inaccurate Totals in Workspace Freeform Tables

Forum|Forum|7 years ago
September 20, 2018
5 replies
6099 views

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:

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

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

Thanks in advance.

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by darkstar1313

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.

Andrey_Osadchuk

Level 10

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.

M

mattravlichAuthor

Level 2

Hi Andrey,

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

Am I looking in the correct area?

Thanks.

D

darkstar1313Accepted solution

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.