MY approach is to find "worst" usersession in order to take analysis from "holistic" point of view.
You can built a table using usql to have the "big picture". Base on that add to your dashboard deep dashlet base on usql.
SELECT totalErrorCount, userExperienceScore, * FROM usersession WHERE useraction.application="Your_Application" and userExperienceScore="FRUSTRATED" order by totalErrorCount desc
Thanks for replies.
I have created below query from which am able to pull out all the frustrated users user action. But am not able to pull out only frustrated user actions from those. Is there any solution on below query.
SELECT userId, userExperienceScore, useraction.name, useraction.apdexCategory FROM usersession WHERE userExperienceScore IS"FRUSTRATED" AND useraction.serverTime > 12000
userExperienceScore is session level, it takes into account all of the actions in the session so you can end up including the user actions that have the (action level) apdex category of tolerating or satisfied as long as the session itself is classified as having a frustrated (session level) userExperienceScore.
If you only want frustrated actions you need to pull from the useraction table (not the usersession table) and you will filter to apdexCategory (not usersession.userExperienceScore).
That's what my example posted earlier does.