Forum Discussion
Calculating yield for production data
Hi all, I'm trying to calculate % yield for some test rig data. Each product, identified by a unique serial number goes through the test and gets a pass of fail result. What I want to do is use t...
Hi Anonymous ,
Thank you for your help! However this is returning a result of 100% and I'm expecting it to be just under that. How do I bring in the date/time element? I need to count the Pass results only for the serial numbers that have passed on the latest test.
Hope that makes sense.
Many thanks
| VIDATE | VITIME | SERIAL_NUMBER | TEST_OUTCOME |
| 17/07/18 | 15:27:38 | 670W16 | PASS |
| 17/07/18 | 15:38:29 | 670W16 | FAIL |
| 17/07/18 | 15:40:20 | 670W16 | PASS |
| 17/07/18 | 15:41:34 | 670W16 | PASS |
| 14/09/17 | 11:56:07 | 5087W3 | PASS |
| 21/09/17 | 9:23:53 | 5062H6 | PASS |
| 14/09/17 | 11:54:07 | 5057H8 | PASS |
| 05/07/17 | 7:59:39 | 357R35 | FAIL |
| 11/07/17 | 12:31:16 | 357R35 | FAIL |
| 02/03/17 | 10:24:00 | 357R35 | PASS |
So you need those bold one with pass status??
Flag=
var Latest_Status_time = CALCULATE(Max(Sheet5[VITIME]),ALLEXCEPT(Sheet5,Sheet5[VIDate]),filter(Sheet5,Sheet5[Status]="Pass")
Return
Sumx(Sheet5,if(Sheet5[VITIME]=Latest_Status_time,1,0)
it will return 1 for latest time with pass status.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.