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.
Please sign in to leave a comment.