Concatenate top 5 defects
Hi Team.
I have a table storing the defect timestamp and the reject code as follows:
I need to group the defects by "DefectTime" and display a field with the top 5 defects for the specific date, also I need to show between parenthesis the percentage of the reject code according to the total of recorded defects in that hour, something as follows:
The "Total", "Passes", "Failed" and "Yield" was already calculated in another custom table, But I'm getting stuck in the Top 5 defect calculation as I have no clue on how to get that information in Sisense, I mean concatenate the top 5 reject codes on an hourly basis and also calculate the yield from the total of defects in the same field as there is no limit or top function in Sisense.
I will appreciate any suggestion on how to get to that result.
Regards.
-
Hi Jimena,
you would need to use Rank in subquery to get that, and then use where to limit results ( you can calcualte percentages in the same query). If you wish we could have a quick meeting and I could walk you through it. Please contact me under michael.becker@qbeeq.pl if you would be interested in such meeting.
Regards,
Michał
Please sign in to leave a comment.
Comments
1 comment