I'm having difficulty in getting the exact query to get the exact count of user action. E.g (Login count).
Compared it to the available custom chart but it doesn't match.
Custom chart metrics:
Mobile app key user action Action count (by key user action, OS, Apdex category) [mobile, custom] (Sum)
Here is the usql.
SELECT count(*) as [Login] FROM usersession WHERE useraction.application='My App' AND useraction.name IN ('Log in')
ok now i see, you are counting sessions (count(*) FROM usersession), where your action is present (maybe more than once), try to change it this way to count every action (not session):
SELECT count(*) as [Login] FROM useraction WHERE application='My App' AND name IN ('Log in')