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