Hi, is it possible to query data in New Relic to get the average transaction rate per second over some period of time?
Thanks @philweber that definitely helps. To go a step further, the documentation states that omitting TIMESERIES will provide the rate value averaged over time. Is there a way to get other stats like, min, max, percentile for the rate value over time?
I do not know of a way to do that, since NRQL does not support taking the function of a function (for example,
max(rate())). As far as I know, you would have to get the per-minute rate values and insert them as an attribute of a custom event. Then you could get the min, max, etc. of that custom attribute.