Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
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