I’d like to build a report to display the median error count of all our user sessions (how many errors does a user see in a session).
I have the current query which will show me counts for individual sessions:
SELECT count(*) from JavaScriptError where appName = '<app name>' FACET . browserInteractionId TIMESERIES 1 week SINCE 4 weeks ago
but I’m not sure if new relic supports using those counts in aggregate. Is there a query I can use to meet what I am looking for?