topic User session Query vs. Custom chart in Real User Monitoring

User session Query vs. Custom chart

JhonKenneth — Wed, 31 Aug 2022 09:44:35 GMT

Hi All,

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')

Re: User session Query vs. Custom chart

rastislav_danis — Mon, 30 Aug 2021 12:26:17 GMT

Have you tried setting older timeframe (f.e. -2h to -1h) ? USQL provides data only for finished (non live) sessions.

Re: User session Query vs. Custom chart

JhonKenneth — Mon, 30 Aug 2021 13:31:43 GMT

Yes rastislav_danis tried it but it doesn't match. It might be USQL only deals with the non bouncing session? and custom chart catch it all?

Re: User session Query vs. Custom chart

rastislav_danis — Tue, 31 Aug 2021 06:34:59 GMT

you can try to focus on non bounced sessions with condition "where usersession.bounce IS false"

Re: User session Query vs. Custom chart

rastislav_danis — Tue, 31 Aug 2021 07:06:12 GMT

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')

Re: User session Query vs. Custom chart

JhonKenneth — Wed, 01 Sep 2021 11:41:12 GMT

rastislav_danis already tried the query above but still count is not equal. Appreciate the response. 😊

Re: User session Query vs. Custom chart

rastislav_danis — Thu, 02 Sep 2021 06:32:40 GMT

Yes i also found that results are not matching. I'm not 100% sure on how mentioned metric is calculated, so it's hard to compare.

Re: User session Query vs. Custom chart

Anish — Sat, 19 Feb 2022 14:00:59 GMT

@JhonKenneth

Even I am facing same issue. Were you able to find any solution?

Thanks,
Anish