Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following requirement. I have 1.3 million test records and I'm trying to get to a right first time percentage. Below I have the sample data. This will value will be going in a text box initially, but will also be used as an expression against the Station as well to see a % Right first time against each test station.
SerialNo | Station | Passed | TestNum | |
001 | Pack1 | N | 9001 | |
001 | Pack1 | N | 9002 | |
001 | Pack1 | Y | 9003 | |
002 | Pack1 | Y | 9004 | |
003 | Pack1 | Y | 9005 | |
004 | Pack2 | Y | 9006 | |
005 | Pack2 | N | 9007 | |
005 | Pack2 | Y | 9008 | |
Serial No 1 & 5 failed the first test, and needed to be retested | ||||
Right First Count | 3 | |||
Total Items | 5 | |||
Right First Time % | 60% |
Not sure what is the right tool for the job?
I am not sure, What is your question?
Not sure what is the right tool for the job?
What does mean this?
Hi Anil, by tools i really mean function. for example is it an aggr function, or an internal resident load, or a count if etc.
Steve
Please see attached and hope this helps...