topic Re: Percentile calculation in DQL

Percentile calculation

enrico_afkl — Fri, 12 Jun 2026 10:53:35 GMT

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 🙂 !

Re: Percentile calculation

p_devulapalli — Thu, 11 Jun 2026 23:43:53 GMT

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

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

Re: Percentile calculation

enrico_afkl — Wed, 24 Jun 2026 12:41:39 GMT

Thank you very much! With this query, I now have the following:

timeseries total=avg(log.prgoffer.foapi.baminfo.soap.duration) by: {baminfo.provider}
| fieldsAdd p99 = arrayPercentile(total, 99)
| fieldsRemove timeframe, interval, total

A chart showing the 99th percentile by category.

Is it possible to see how the P99 has changed over time for each provider? (Using a line chart)

Re: Percentile calculation

p_devulapalli — Thu, 25 Jun 2026 00:40:02 GMT

@enrico_afkl Yes, you might need to modify the DQL a bit, please try the below

timeseries p99=percentile(log.prgoffer.foapi.baminfo.soap.duration, 99) , by: { baminfo.provider }

Re: Percentile calculation

enrico_afkl — Thu, 25 Jun 2026 06:56:16 GMT

I and thanks for your answer 🙂
I thought that was the right solution but when I tried I had "no records" answer whereas with the previous query I do have values within the same range so I am puzzled.

do you understand why?

Re: Percentile calculation

p_devulapalli — Thu, 25 Jun 2026 07:09:03 GMT

@enrico_afkl The data that you are querying , is that a timeseries data? What if you try to get a average , do you see data?

timeseries avg(log.prgoffer.foapi.baminfo.soap.duration) , by: { baminfo.provider }

Re: Percentile calculation

enrico_afkl — Thu, 25 Jun 2026 07:36:24 GMT

I did this for the first query, but now i would like to have the evolution in time with a line chart