Get Average Transaction Rate

Hi, is it possible to query data in New Relic to get the average transaction rate per second over some period of time?

Hi, @marcin.czauz: I don’t think New Relic captures per-second metrics by default. You may use the NRQL rate() function to get the per minute transaction rate.

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.