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
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.