topic Difference between queried number of users and number on application overview in Real User Monitoring

Difference between queried number of users and number on application overview

AhmedKhaled_94 — Thu, 21 Nov 2024 10:16:25 GMT

Hello,

One of our customers is trying to perform analysis on their user analytics, seeing how many of their users are opening from different mobile version etc.

One of the queries we are trying to get is the total number of users.

I have tried multiple queries like:

SELECT COUNT(*) from userSession WHERE *application filter*

SELECT COUNT(DISTINCT *) from userSession WHERE *application filter*

SELECT COUNT (user_Id) from userSession WHERE *application filter* (with and without distinct)

I have tried used InternaluserId as well

There is always a huge difference between the resulting number, and the number that is previewed in the user experience tile in the application overview below.

SO the tile would be showing 11.6k and the queries would be returning 15k.

Any idea how this tile is created? what metric can I use to get a similar number?

Best Regards,

Ahmed

Re: Difference between queried number of users and number on application overview

PacoPorro — Thu, 21 Nov 2024 08:32:30 GMT

If you're in a timeframe with live sessions, those won't be visible in the USQL results.

Re: Difference between queried number of users and number on application overview

PacoPorro — Thu, 21 Nov 2024 08:34:54 GMT

Can I suggest you to check this post?
https://community.dynatrace.com/t5/Real-User-Monitoring/Unlock-the-full-potential-of-Digital-Experience-Monitoring-with/td-p/248747

Re: Difference between queried number of users and number on application overview

AhmedKhaled_94 — Wed, 04 Dec 2024 06:30:32 GMT

Update: If you need to have a tile with the same number of users as the application overview tile, you can use the following metric 'builtin:apps.other.userCount.osAndVersion-std'