topic Re: User Session Query Language - Percentile in Real User Monitoring

User Session Query Language - Percentile

julien_egron_ex — Tue, 25 May 2021 11:52:46 GMT

Hi,

I would like to get percentile with uSQL.

Exemple :

SELECT useraction.name,city, browserFamily, count(useraction.duration), MEDIAN(useraction.duration), PERCENTILE(useraction.duration, 90) FROM usersession WHERE useraction.name='Action1' GROUP BY browserFamily,city,useraction.name

Julien

Re: User Session Query Language - Percentile

kannan_muthiah — Thu, 20 Jun 2019 20:35:03 GMT

I have the exact same need. It will be so useful if this is available. Did you get an answer?

Re: User Session Query Language - Percentile

sara_al-hayale — Mon, 16 Oct 2023 14:42:11 GMT

Hi Julien,

This is not currently possible but there is already an RFE: https://community.dynatrace.com/spaces/483/dynatrace-product-ideas/idea/216063/rfe-percentile-aggregation-for-usql.html

Judging by the comments on there, it is on the roadmap and will be a possibility in the second half of 2019