I have a use case where I need to limit a query to only those clients with at least 100 transactions. I can do this easily enough in SQL, but can’t seem to find a way in NRQL. I found at least one request for adding a HAVING equivalent, but that was from three years ago. This could also be accomplished if we were able to use aliasing. I have to think plenty of us would find both of these features quite useful.
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.