topic Re: USQL - group by action duration in Dashboarding

USQL - group by action duration

skrystosik — Wed, 31 Aug 2022 10:03:44 GMT

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

Re: USQL - group by action duration

skrystosik — Mon, 01 Jul 2019 07:46:34 GMT

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

Re: USQL - group by action duration

Romanenkov_Alex — Mon, 01 Jul 2019 10:34:11 GMT

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