My goal is to find all URLs (“name” in Transactions) which were hit more than 1000 times during same User session (“request.headers.session” in Transactions).
I tried this NRQL “SELECT count(*) from Transaction since 30 days ago FACET request.headers.session, name LIMIT 2000”
It brings some Transactions, but not all. Because there are plenty of request.headers.session + name combinations with low occurrences, so total amount > 2000
It would be great if I can filter out low-volume transactions to get only high-volume
Please advise how to do it in New Relic.