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
BedrockMission!

Learn More

View all

Sign in to view all badges

Inaccurate Totals in Workspace Freeform Tables

Avatar

Avatar
Validate 1
Level 4
mravlich
Level 4

Likes

42 likes

Total Posts

18 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Validate 1
Level 4
mravlich
Level 4

Likes

42 likes

Total Posts

18 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
mravlich
Level 4

20-09-2018

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Shape 1
Level 2
darkstar1313
Level 2

Likes

9 likes

Total Posts

17 posts

Correct Reply

1 solution
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Shape 1
Level 2
darkstar1313
Level 2

Likes

9 likes

Total Posts

17 posts

Correct Reply

1 solution
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
darkstar1313
Level 2

21-09-2018

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.

Answers (4)

Answers (4)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

470 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

470 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

01-10-2018

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.

Avatar

Avatar
Validate 1
Level 4
mravlich
Level 4

Likes

42 likes

Total Posts

18 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Validate 1
Level 4
mravlich
Level 4

Likes

42 likes

Total Posts

18 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
mravlich
Level 4

04-10-2018

Thank you. This is very helpful.

Avatar

Avatar
Validate 1
Level 4
mravlich
Level 4

Likes

42 likes

Total Posts

18 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Validate 1
Level 4
mravlich
Level 4

Likes

42 likes

Total Posts

18 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
mravlich
Level 4

20-09-2018

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

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

523 likes

Total Posts

943 posts

Correct Reply

254 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

523 likes

Total Posts

943 posts

Correct Reply

254 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

20-09-2018

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.