JMP yield % not matching with Power BI and ExcelHi 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.79% | 98.26% | -0.53% |
Feb | 98.77% | 98.77% | 98.40% | -0.37% |
Mar | 98.91% | 98.91% | 98.49% | -0.42% |
Apr | 98.36% | 98.36% | 96.37% | -1.99% |
May | 99.34% | 99.34% | 97.73% | -1.61% |
Quality and Process EngineeringRe: JMP yield % not matching with Power BI and ExcelAs 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.
Re: JMP yield % not matching with Power BI and ExcelIn 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)
Re: JMP yield % not matching with Power BI and ExcelThis 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%
