When looking at an user session for the same user in the UI vs the query view, the results are different. Is there a reason for this? We are trying to extract some data for metrics, but since they do not match up, we are hesitant to use the query data.
The query was automatically generated by Dynatrace when I clicked on the "User Sessions Query" button
I assume the session duration in the query result set is in milliseconds (2nd screenshot) so that would be around 35 min, which is off from the 31 min shown in the UI (1st screen shot)
The question is what does it mean average in both examples. It may be possible that USQL without filtering by timeframe is considered all data for this user. User Session view is limited to timeframe set in environment. But this is only my speculation...