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?


#1

Hi
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


#2

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