Percentile calculation

[enrico_afkl]

Hello,
I have this query and would like to find out which endpoints fall within the 98th percentile:

timeseries {
totalCalls = sum(log.prgoffer.foapi.baminfo.httpmethod,
filter: isNotNull(endpoint)),

successCalls = sum(log.prgoffer.foapi.baminfo.httpmethod,
filter: isNotNull(endpoint)
and matchesValue(baminfo.exception,"OK")),

by:endpoint
},

interval: 5m

| fieldsAdd successRatio = successCalls[] / totalCalls[] * 100
| fieldsRemove successCalls, totalCalls

thanks for all support 🙂 !

[p_devulapalli]

@enrico_afkl You can try the "arrayPercentile", please see below

https://docs.dynatrace.com/docs/shortlink/array-functions#array-percentile