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

Feature Idea: Ability to write more complex WHERE clauses, e.g. use aggregate functions



Many of the queries I want to run involve some level of a sub-query or aggregate function in the WHERE clause… but I don’t think this is currently possible - as such I’d really like to strongly request this.

E.g. I’d like to get a list of users/sessions that do “lots of X”, but “very little of Y”. In pseudo NRQL it would be something like:

SELECT sessionID WHERE count(name = 'urlX') >= 500 AND count(name = 'urlY') < 10 SINCE 30 days ago

I think currently the only way I could do this is to extract all of the data, dump into a SQL database, and run my queries there using sub-queries, group by, etc.

Is there any other option? and/or is there an ETA for any new features like this?

New Relic Edit

  • I want this too
  • I have more info to share (reply below)
  • I have a solution for this

0 voters

We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.



Hi Stephen

I don’t think there’s a way to achieve the results you are looking for right now - We do have similar feature ideas open right now, though no ETA to provide at the moment. I have gone ahead and filed a new feature idea for you with your specific use case here. I’ve also added a poll to your post for others to vote on here.