My table rows are not adding up correctly to the top number. | Community
Skip to main content
E
erinwestlake
New Participant
June 6, 2023
Solved

My table rows are not adding up correctly to the top number.

  • June 6, 2023
  • 1 reply
  • 749 views

As you can see in the picture below, the orders of our products are not adding up correctly to the number at the top. I am curious why this would be and how to fix it. 

 

Thanks! 

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 Jennifer_Dungan

What is your dimension breakdown? Product?

 

If there are multiple products in the same order, the total orders will be de-duplicated.

 

Example: If I go to your site and purchase "Item A", "Item B" and "Item C" in the same order, the report will look like:

 

                               Orders

                                    1

Products

     Item A                     1

     Item B                     1

     Item C                     1

 

 

You wouldn't count this as "3" orders when all three products were purchased in the same order, with the same Order ID / Transaction ID... it's still one order.

1 reply

Jennifer_Dungan
Jennifer_DunganAccepted solution
New Participant
June 6, 2023

What is your dimension breakdown? Product?

 

If there are multiple products in the same order, the total orders will be de-duplicated.

 

Example: If I go to your site and purchase "Item A", "Item B" and "Item C" in the same order, the report will look like:

 

                               Orders

                                    1

Products

     Item A                     1

     Item B                     1

     Item C                     1

 

 

You wouldn't count this as "3" orders when all three products were purchased in the same order, with the same Order ID / Transaction ID... it's still one order.

    B
    BrianAu1
    Employee
    June 6, 2023

    @jennifer_dungan is correct - this is a scenario of the Orders metrics having different contexts when applied at different dimension levels (Top Line vs. Product line item level). Conceptually in the case of orders where the metrics are dually applied at a per-product line item level AND against corresponding top line overall count, the top line represents the de-duplicated total orders metric count. The per-product line items that are not de-duplicated actually represents more an 'order involved count' since it's a many-to-one data relationship of products within a given order.

      Terms & ConditionsAccessibility statement

      Loading footer...