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

How to chart user sessions that include a particular action?

mony_r88
Contributor

How to chart user sessions that include a particular action?


3 REPLIES 3

skrystosik
DynaMight Guru
DynaMight Guru

You have to use USQL:

https://www.dynatrace.com/news/blog/usql-goes-ga-data-driven-decisions-with-powerful-queries-and-adv...

Using such query you can find all sessions that contains particular action according to your needs.

Sebastian


Regards, Sebastian

AK
Mentor

You can add filter for that particular user action. Refer a screen grab below,

Thanks...


jonathan_schull
Dynatrace Advisor
Dynatrace Advisor

Hi Monica,

Sebastian is correct, you can do this using USQL. Specifically if you pull data from the usersession table, and check that there is a useraction.name matching the action you are interested in, it will return all user sessions that include that particular action. Here is an example:


SELECT COUNT(*), browserFamily 
FROM usersession
WHERE useraction.name = "/easytravel/rest/journeys/"
GROUP BY browserFamily


This will return the count of user sessions, split by browser, that contain the user action "/easytravel/rest/journeys/". Once you get this down you can play around with the metrics you are bringing in to chart exactly what you would like.


Cheers,

Jonathan