USQL

[cp_patel]

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

[alonso_decosio · Accepted 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