Thanks for the feedback - really appreciate it. I'm currently working it out in Excel and this is the way i'm looking at it:
Currently i'm getting the data in three columns:
time (minute) > requests_per_minute > avg_response_time
I can then dismiss the time column, then order it by requests_per_minute. This will give multiple entries for 1rpm, 2rpm, etc. all the way up to around 2000. I'd then like to average these avg_response_time results for each rpm, and chart the result as a scatter graph with rpm on the x-axis and the averaged avg_response_time on the y-axis.
Does this make sense? It's a few steps in Excel but i'm sure i can break it down into splunk language...
... View more