cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

USQL

cp_patel
Participant

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.  

 

cp_patel_1-1621948723792.png

 

Thanks & Regards,

Chandni

1 REPLY 1

alonso_decosio
Dynatrace Advisor
Dynatrace Advisor

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

 

Screen Shot 2021-05-25 at 11.03.27 AM.png

 

I hope this helps.

 

Thanks,

Alonso