Average of Percentiles

Dashboard: https://insights.newrelic.com/accounts/2110222/dashboards/878186

What query can I use to get the average of these API endpoints?
I’ve tried “SELECT average(percentile(totalTime, 95)) FROM Transaction SINCE 7 DAYS AGO WHERE appName = ‘ms-sports-prod’ OR appName = ‘ms-leagues-prod’” to no avail.

Hi, @reginald.campbell: NRQL does not currently support taking the function of a function. You may wish to add your voice to this feature idea: