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

How to select certain hours every day in NR Insights?


Is possible, for example to select a response time only from 5am to 6am every day in the query

SELECT percentile(duration * 1000, 95) AS ‘Response time’ FROM Transaction WHERE (name = ‘WebTransaction/login (POST)’) From 5am to 6am TIMESERIES SINCE 1 day ago COMPARE WITH 1 week ago EXTRAPOLATE


Hi, @Di.Feng: Try WHERE hourOf(timestamp) = 5.