cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

USQL - group by action duration

skrystosik
DynaMight Guru
DynaMight Guru

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

 

Regards, Sebastian
2 REPLIES 2

skrystosik
DynaMight Guru
DynaMight Guru

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


Regards, Sebastian

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


Featured Posts