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

nrql

#1

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.


#2

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 
TIMESERIES