28 Jun 2019 10:43 PM - last edited on 31 Aug 2022 03:03 AM by MaciejNeumann
Hello, I’m curious if it is possible to get such chart from USQL:
I was trying multiple ways but I think it is not possible. But maybe someone has idea how to get action duration distribution for particular user action? 🙂
Solved! Go to Solution.
Ok there is such option:
SELECT MEDIAN(duration) as "Duration (ms)", COUNT(*) as "Count" FROM useraction WHERE useraction.name IN ('Loading of page /') AND usersession.userType IS "REAL_USER" GROUP BY duration ORDER BY duration ASC
Here is example. Result looks like this:
It would be great if there will be option for defining steps manually. But this is fine as well 🙂
Thank you, this result is very interesting. In AppMon i creating three business transaction (fast, slow, very slow) and then put them on one chart.
With this USQL query we can get response time distribution in several clicks on dashboard.
Maybe later we will have these futures:
And then it will possible to create ranges (fast, slow, very slow) and display result on dashboard.