USQL - group by action duration

[skrystosik]

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? 🙂

Sebastian

[skrystosik · Accepted 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 🙂

Sebastian

[Romanenkov_Alex]

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:

case
when

And then it will possible to create ranges (fast, slow, very slow) and display result on dashboard.

Regards,

Alexander