10 Sep 2018
08:58 AM
- last edited on
25 May 2021
04:52 AM
by
MaciejNeumann
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
Solved! Go to Solution.
I have the exact same need. It will be so useful if this is available. Did you get an answer?
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