Showing results for 
Show  only  | Search instead for 
Did you mean: 

Data USQL (No live) vs Data Explore ,with the same timeframe , don't present same information

Dynatrace Enthusiast
Dynatrace Enthusiast

I have a question about Data Explorer, I am using the metric of "User count - estimated (by Os, app version). And I have also used USQL to obtain the number of users. For both cases in the Yape application and for a single day December 15.
But the results are different. Does anyone know what the information in the data explorer is based on? Shouldn't the information in this case match the information from USQL and Data Explorer?



Dynatrace Advisor
Dynatrace Advisor

Hi @PierreGutierrez ,

USQL is based on ElasticSearch aggregation and taken account only end user's session. 
Data Explorer is based on Cassandra (TimeSeries) , so persistent data. 
As a result of, there exists little gap or shift.

Make sure you use comparable USQL and Explorer metrics. 

For the user session count you can use:or this one if you want all users, including anonymous users:

SELECT Count(*) FROM usersession


For user count use the following for tagged users:

SELECT Count(DISTINCT(userid)) FROM usersession


More appropriate would be this metric in Data Explorer builtin:apps.other.sessionCount.osAndGeo.  versus USQL Count(*) FROM usersession
Built-in metrics | Dynatrace Documentation


In other hands, you got this warning message in Data Explorer : 

For the dimension 'App Version' the number of dimension values was reduced to its TopX of 9

which tells the metric has a top x defined and the warning indicates that if some dimensions are missing. As consequence, only the topmost app versions will be used for aggregation...
This could be truncated your data too.

Hope this helps,