JMP yield % not matching with Power BI and Excel

Question

Hi All, Good Day.

Refer below tables showing the gaps between excel, power BI and the JMP with the same set of raw data (JMP % mostly not comparable to Excel and power BI). I hv attached the raw JMP file as well. Could anyone advice how to make JMP yield % is comparable to excel and Power BI. I am using ver 17. tks

Monthly

Excel Yield

Power BI Yield

JMP Yield (Ave)

Delta %

in  JMP

Jan

98.79%

98.26%

-0.53%

Feb

98.77%

98.40%

-0.37%

Mar

98.91%

98.49%

-0.42%

Apr

98.36%

96.37%

-1.99%

May

99.34%

97.73%

-1.61%

RAW data for Yield gap Checking.jmp

Ressel · Answer

This should also help for clarification. Check the two cells to the very right in the attached sheet. These show you the differences between the two possible mean values: 98.79% vs 98.27%

Raw data JAN.xlsx

jthi · Answer

In JMP it would be best to create Summary table and perform calculations and plot from that.

You can also calculate the yield in the original table using Col Sum()s with correct byVars (month (and year)) and then use that for plotting.

(the provided JMP table did have incorrect data types so the results might be incorrect and I'm not sure which formula to use for yield calculation in this case)

WebDesignesCrow · Answer

As a user of Excel Pivot Table to calculate yield through aggregate sum (Power BI should be similar).

You have to put a summary table or tabulate to add the formula column "sum of good die before ORT/ sum of total inspected qty".

JMP use average yield (which is not same with the formula above)

If you need daily report through JMP, I suggest you automate it using JSL scripting or workflow.