25 May 2021 06:21 AM - last edited on 30 Jun 2021 06:24 AM by MaciejNeumann
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,
Solved! Go to Solution.
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.