Error in insights on query

Build on New Relic Data Queries & Synthetic Scripts
,
#1

Hi, I am getting Something went wrong while executing your query.

while running this query:

SELECT max(p95) FROM (
   SELECT percentile(totalTime, 95) AS p95 FROM Transaction 
   WHERE appName='app_name' AND name='OtherTransaction/nice_name' 
   TIMESERIES 1 minute
) SINCE 60 minutes ago

I want to know the max 95% percentile per minute in the last 1 hour. The same query working when calculating average instead of 95 percentile.(below query working without any issues:)

SELECT max(ave) FROM (
   SELECT average(totalTime) AS ave FROM Transaction 
   WHERE appName='app_name' AND name='OtherTransaction/nice_name' 
   TIMESERIES 1 minute
) SINCE 60 minutes ago
#2

Hi @govind, I looked around and it appears that the percentile( ) function isn’t compatible with nested aggregation, as noted here. From that post, it sounds like this is something we’re looking to possibly support in the future.

2 Likes