In our QuickSight line chart showing test failure rates over the last 7 days, we’ve applied two filters: one to show only methods with a failure rate greater than 0, and another to display the top 10 method names. Can you explain how QuickSight determines these ‘top 10’ methods? Is it based on the average failure rate across the week, the peak failure rate, or some other criteria? Also, how might this selection method impact our interpretation of the most problematic tests?
1 Like
Hello @Giri, I wonder if it would be better to create a denseRank calculation to handle the Top 10 methods so you can specify the criteria you want. Without seeing how it is set up, I am not certain how QuickSight is handling it currently, but I think that route would be a better solution.
Then you can just apply a filter on the visual based on the denseRank calculation to only include values less than or equal to 10. If you need assistance creating the calculated field, let me know what fields you need to reference and the requirements for handling the Top 10 methods. Thank you!
Hello @Giri, did my response help you resolve the issue you are facing? If so, please mark my previous message as the solution. Otherwise, let me know what other questions you have and I can help guide you further. If we do not hear back from you in 3 days, I will close out this topic. Thank you!
Hello @Giri, since we have not heard back with any remaining questions, I will mark my response as the solution. Thank you!
Hello @DylanM , Thanks for your descriptive solution . I will explore and try out the solution you provided and let you know . Sorry for delay in reply , busy in some other work . Thank you .
1 Like