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