cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

User Session Query Language - Percentile

julien_egron_ex
Newcomer

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

 

2 REPLIES 2

kannan_muthiah
Newcomer

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


sara_al-hayale
Dynatracer
Dynatracer

Hi Julien,

This is not currently possible but there is already an RFE: https://answers.dynatrace.com/spaces/483/dynatrace-product-ideas/idea/216063/rfe-percentile-aggregat...

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