Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

NRQL vs Metrics Value difference

nrql

#1

When i try to get transaction count for specific transaction for a specific minute from NRQL and compare that value with the value we got from the Insight dashboard (metrics based) .I can see a huge variance. I have attached screen shots of the two sources. Can some explain the possible reasons for this ? new_relic_01


NRQL vs Metrics Data Difference
#2

When I try to get transaction count from NRQL for specific minute and compare that with the value I got from the Insight dashboard. I can see a huge difference. Can someone explain why ? new_relic_01new_relic_02


#3

You have two different time windows.


#4

You may also want to look at the rate function which could give better results.


#5

In addition to the advice from @stefan_garnham & @6mm, check out this post in which @philweber mentions that there is a limit to the Insights events collected.