https://community.dynatrace.com/t5/DQL/Percentile-calculation/m-p/300647#M3382 <P><a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/98941">@enrico_afkl</a>&nbsp;You can try the "<SPAN>arrayPercentile", please see below</SPAN></P><P><A href="https://docs.dynatrace.com/docs/shortlink/array-functions#array-percentile" target="_blank">https://docs.dynatrace.com/docs/shortlink/array-functions#array-percentile</A></P><P>&nbsp;</P> Thu, 11 Jun 2026 23:43:53 GMT p_devulapalli 2026-06-11T23:43:53Z https://community.dynatrace.com/t5/DQL/Percentile-calculation/m-p/300617#M3381 <P>&nbsp;</P> <P>Hello,<BR />I have this query and would like to find out which endpoints fall within the 98th percentile:<BR /><BR />timeseries {<BR />totalCalls = sum(log.prgoffer.foapi.baminfo.httpmethod,<BR />filter: isNotNull(endpoint)),<BR /><BR />successCalls = sum(log.prgoffer.foapi.baminfo.httpmethod,<BR />filter: isNotNull(endpoint)<BR />and matchesValue(baminfo.exception,"OK")),<BR /><BR />by:endpoint<BR />},</P> <P>interval: 5m</P> <P>| fieldsAdd successRatio = successCalls[] / totalCalls[] * 100<BR />| fieldsRemove successCalls, totalCalls<BR /><BR />thanks for all support <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> !</P> Fri, 12 Jun 2026 10:53:35 GMT https://community.dynatrace.com/t5/DQL/Percentile-calculation/m-p/300617#M3381 enrico_afkl 2026-06-12T10:53:35Z https://community.dynatrace.com/t5/DQL/Percentile-calculation/m-p/300647#M3382 <P><a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/98941">@enrico_afkl</a>&nbsp;You can try the "<SPAN>arrayPercentile", please see below</SPAN></P><P><A href="https://docs.dynatrace.com/docs/shortlink/array-functions#array-percentile" target="_blank">https://docs.dynatrace.com/docs/shortlink/array-functions#array-percentile</A></P><P>&nbsp;</P> Thu, 11 Jun 2026 23:43:53 GMT https://community.dynatrace.com/t5/DQL/Percentile-calculation/m-p/300647#M3382 p_devulapalli 2026-06-11T23:43:53Z