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

Compare Current Year to Last Year Performance



I am looking to create a chart/table that will compare metrics of ‘Month to Date - Last Year’ to ‘Month to Date - Current Year’ of site load time. I am looking for a nrql query that will change as the month does.


Hi, @ahaden: Assuming you have at least 12 months of Insights data retention, try this:

SELECT average(duration) 
FROM PageView
WHERE appName = 'My Application' 
SINCE this month 
COMPARE WITH 12 months ago