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