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
vs
SELECT useraction.application, useraction.name, COUNT(*) FROM useraction WHERE useraction.application ="My_App" AND useraction.apdexCategory=“FRUSTRATED” GROUP BY useraction.application, useraction.name
