topic Re: USQL- Frustrated user actions , their count by app in Dashboarding

USQL- Frustrated user actions , their count by app

shahrukh_niazi — Tue, 30 Mar 2021 07:31:12 GMT

I have created a dashboard which allows me to see end user experience and how many users are satisfied & how many had frustrated actions

I am looking for a way to list in table format, if possible, all user actions, the count of frustrated which had frustrated experience

I tried using this usql but it is showing ALL the apps. I want to restrict it to "My_App" only and show me the count as well

select name, count(name) from useraction where apdexCategory IS "FRUSTRATED" group by name order by count(name)

USER_ACTION_Name , COUNT_of_Frustrated

Re: USQL- Frustrated user actions , their count by app

ChadTurner — Wed, 24 Mar 2021 13:00:43 GMT

So if you want a single value of all the frustrated users you can use the following string:

SELECT COUNT(useraction.name) FROM usersession WHERE useraction.application="My_App" AND userExperienceScore IS "FRUSTRATED"

Or you can use this, which give you a table view including the action name and the count of the frustrated users on that given applications as defined: SELECT useraction.name, COUNT(userExperienceScore) FROM usersession WHERE useraction.application ="My_App" AND userExperienceScore="FRUSTRATED" GROUP BY useraction.name

Re: USQL- Frustrated user actions , their count by app

trevor_masseng1 — Mon, 29 Mar 2021 16:05:38 GMT

While the query Chad gave you correctly adds the Application filter, it is querying the User Session's Apdex (or User Experience Score).

You can use this query to pull Apdex instead, displaying the user action name, the amount of times it was FRUSTRATED for Apdex, only pulling data for FRUSTRATED visits (Frustrated User Experience Score):
SELECT useraction.name, COUNT(*) FROM usersession WHERE useraction.application ="My_App" AND useraction.apdexCategory="FRUSTRATED" AND userExperienceScore="FRUSTRATED" GROUP BY useraction.name

Re: USQL- Frustrated user actions , their count by app

ABB — Tue, 08 Feb 2022 17:31:06 GMT

Whether its count of frustrated user actions or Top user actions, should we get it from usersession table or useraction table? I see counts differ for these. Not sure if this is our company instance, but when i use the user session table the where clause doesn't work and gets all the application whereas if i use the useraction table, my results are limited to the application name.

Re: USQL- Frustrated user actions , their count by app

AgataWlodarczyk — Thu, 17 Feb 2022 11:17:17 GMT

You can only do it for key user actions.

It would be beneficial if you also use parents to add another column/split by application. Otherwise, you might end up with the same user action name multiple times but you don't know to which app it belongs.

You can plot the apdex score user action per application in a table.

but that does not give you the count for each category.

This can only be achieved in usql.

Re: USQL- Frustrated user actions , their count by app

ABB — Thu, 17 Feb 2022 18:07:50 GMT

Thank you! I also got a response on my other posting that explains the difference between UserSessions Vs UserActions. I used this guidance for Top User Actions and now I am not getting user actions with multiple same names.

https://community.dynatrace.com/t5/Dashboarding/Top-User-Actions-UserSession-table-or-UserAction-table/m-p/180416#M2185

However, for identifying frustrated user actions through a USQL, if we use useraction.apdexCategory="FRUSTRATED", it is also showing non key user actions. Did you meant to say that custom metrics will only work for key user actions?

Re: USQL- Frustrated user actions , their count by app

christian_gusta — Fri, 18 Feb 2022 10:44:18 GMT

You can use your initial query you just need to add a filter for the app like this:

select name, count(name) from useraction where apdexCategory IS "FRUSTRATED" and application = "My App" group by name order by count(name)