Inaccurate Totals in Workspace Freeform Tables | Community
Skip to main content
mattravlich
Level 2
Sep 20, 2018 10:38 PM UTC
Solved

Inaccurate Totals in Workspace Freeform Tables

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    darkstar1313Accepted solution
    Level 2
    Sep 21, 2018 8:18 AM UTC

    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 reply

    5 replies

    mattravlichAuthor
    Level 2
    Oct 4, 2018 8:30 PM UTC

    Thank you. This is very helpful.

    Translate
    Gigazelle
    Gigazelle
    Employee
    Oct 1, 2018 8:02 PM UTC

    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.

    Translate
      darkstar1313Accepted solution
      Level 2
      Sep 21, 2018 8:18 AM UTC

      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.

      Translate
        mattravlichAuthor
        Level 2
        Sep 20, 2018 10:58 PM UTC

        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.

        Translate
        Andrey_Osadchuk
        Andrey_Osadchuk
        Level 10
        Sep 20, 2018 10:48 PM UTC

        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.

        Translate
        Terms & ConditionsAccessibility statement

        Loading footer...