I need to do a very simple report on Min, Max and Average Response Time of a certain node summarized by hour. But, instead of true Max values, I need 95th percentile Max (the Max response time ignoring the top 5%). Is it possible?
You can do it, but you'll need to do an Advanced SQL report. You need to get all the response time values, sort them, drop the top 5%, and that max value of what remains is your 95th percentile.
