Expand my Community achievements bar.

Join us for our next community Coffee Break on February 28th! Four of our Analytics Champions will be joining us to discuss Summit tips, best practices, and any of your Analytics questions!
SOLVED

How does "Calculate percentages by row" work?

Avatar

Level 8

Hi there,

 

I think I must be missing something but how does "Calculate percentages by row" work? In the table below the logic seems fine for columns (total percentage = 300):

 

Column.PNG

 

However when you switch this to Rows I am shown:

 

row.PNG

 

Which does not total 300% but rather 126.6%.

Thanks


Dave

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
4 Replies

Avatar

Correct answer by
Community Advisor

Avatar

Level 8

Hi there, that video shows it working exactly how I would expect it to work, however as you can see from my screenshot, my work space is not totally 100% per row.

Avatar

Community Advisor

Hi, I think that's cause you may not be using all variable values captured in "*_check" on orders event. Ex. if variable product has four variants (a, b, c, d) captured on order (one unit in each value) and you only arrange 3 variants (a, b, and c) it will show row total only 75% due to missing variant d having rest of the 25%.

Avatar

Level 8
Hi asheeshp - that is correct! Not sure if that should be called a bug or a feature