Graph Builder Caption Box "% of Total" is incorrect

[#1]

Hi, 

In graph builder, the Caption Box "% of Total" metric is not calculating correct values.

Values generated from Tabulate (inset below) are correct. I've highlighted just a few of the discrepant values.

Same result on JMP16.2 & JMP17.2. 

know bug or something new? Can you please review? 

Sample data attached. 

Thanks, 
Ray

[#2 · Accepted solution]

Hey @rbfinner ,

It is because you are returning the % of the total amount of Y-Parameter in graph builder vs the Qty of the X-Parameter vs the total number of rows in the tabulate.  If you add the Y-Parameter to tabulate you will see the difference.

In the caption box control panel turn off the caption box respecting Y (Y-Parameter) and you will get Graph Builder to match tabulate.

Steve

[#3]

@shampton82  -  

So not a bug but user error, mis-understanding on my part of how "% of Total" works.

With y-parameter checked it appears to be: sum(y-parameter values, per factor)/sum(all y-parameter values);

With y-parameter un-checked its more like: N(values, per factor)/N(all values) - which is what I was looking for initially.

Thank you for the correction.

Ray