User Session Query Language - Percentile

[julien_egron_ex]

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

[kannan_muthiah]

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

[sara_al-hayale · Accepted solution]

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-aggreg...

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