topic Re: Top User Actions - UserSession table or UserAction table in Dashboarding

Top user actions - UserSession table or UserAction table?

ABB — Thu, 25 May 2023 13:23:12 GMT

Whether it's the count of frustrated user actions or Top user actions, should we get it from usersession table or useraction table? Need some guidance on this. I see counts vastly differ for both.

In addition, I see another issue- Not sure if this is our company instance, but when I use the user session table, the where clause doesn't work and pulls all the application names, whereas if I use the useraction table, my results are limited to the application name.

SELECT useraction.application, useraction.name, COUNT(*) FROM usersession WHERE useraction.application ="My_App" AND useraction.apdexCategory="FRUSTRATED" GROUP BY useraction.application,useraction.name

SELECT useraction.application, useraction.name, COUNT(*) FROM useraction WHERE useraction.application ="My_App" AND useraction.apdexCategory="FRUSTRATED" GROUP BY useraction.application, useraction.name

Re: Top User Actions - UserSession table or UserAction table

christian_gusta — Wed, 16 Feb 2022 09:25:20 GMT

Hi,

This is explained in the documentation of USQL how the filtering works for primary and secondary "tables" works: https://www.dynatrace.com/support/help/how-to-use-dynatrace/real-user-monitoring/how-to-use-real-user-monitoring/cross-application-user-session-analytics/custom-queries-segmentation-and-aggregation-of-session-data#expand--example-1--36

Re: Top User Actions - UserSession table or UserAction table

ABB — Wed, 16 Feb 2022 21:53:55 GMT

Thanks! This explains it!