USQL

cp_patel — Wed, 30 Jun 2021 13:24:11 GMT

Hi,

I have following requirements please help me with how can I perform them in USQL.

1) Avg. user action per session for specific application through USQL.

2) Avg. session duration for the specific application through USQL.

We want to show both the results with time series graph format. Also let me know if we can present these 2 results in 1 graphical format only(Separate graphs for both will also be fine and will be helpful). Anyhow by custom chart of USQL how is it possible to achieve?

Dynatrace offers following format to show user engagement with the application but in seconds for time user spent per session. So, to change the unit and also the graphical presentation we want to explore some other ways to achieve this.

Thanks & Regards,

Chandni

Re: USQL

alonso_decosio — Tue, 25 May 2021 15:05:58 GMT

Hi Chandni,

You can do something like this:

SELECT endTime, avg(userActionCount), avg(duration) from usersession WHERE useraction.application = "www.angular.easytravel.com" GROUP BY endTime

I hope this helps.

Thanks,

Alonso

topic Re: USQL in Real User Monitoring

USQL

Re: USQL