Difference between queried number of users and number on application overview

[AhmedKhaled_94]

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

[PacoPorro]

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

[PacoPorro]

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

[AhmedKhaled_94 · Accepted solution]

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'