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 the latest test date for each serial number (as each serial number may have gone through multiple tests) and count the amount of pass results. I then plan to divide this number of records by the total number of unique serial numbers in order to get my % yield figure. Here is a sample of the data: 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