My goal is the following:
For a given key user action, I want to find the median visually complete time for each browser type (Desktop, Mobile, and Tablet). I'm using USQL to attempt this, with the following query:
SELECT MEDIAN(useraction.visuallyCompleteTime) FROM useraction WHERE userAction.name="XXXXXXXXX" AND usersession.browserType="Mobile Browser" AND usersession.userType="REAL_USER" AND useraction.application="XXXXX"
The results that I'm getting, however, do not match my tenant. I get a value of 4.37 seconds from the query, and 4.5 seconds from our SAAS tenant. This is a small difference, but I'm wondering if there is any way I can improve my query to get the numbers to match.
So two questions:
- Is my query the correct way to find the median load times of different browser types for a specific action?
- If so, is this difference that I'm seeing just a quirk of Dynatrace? As long as the values from the query are always off from the tenant I'm ok as long as the difference is small.
Solved! Go to Solution.
Did you factor out live sessions in the UI? Also, how exactly did you test in the UI?
Here are a couple of queries I was playing with to test this but I am not really clear on a good way to verify them against the UI:
SELECT MEDIAN(useraction.visuallyCompleteTime) FROM useraction GROUP BY useraction.application, usersession.userType, userAction.name, usersession.browserType
SELECT MEDIAN(useraction.visuallyCompleteTime) FROM useraction GROUP BY useraction.application
Well, there are some potential differences as these systems were built to serve different use cases and not to be compared against each other. However, you can compare the data and for each potential reason there is a solution:
I'm trying to recreate your solution to issue number 2. I want to chart all occurrences of the Login page in the last 2 hours and intervals of 5 minutes. This is my query:
datetime(startTime,"HH:mm","5m") as [Time per 5 minutes],
count(name) as [Occurrences of Login Page]
where name = "Inlogpagina"
group by datetime(startTime,"HH:mm","5m"), name
order by datetime(startTime,"HH:mm","5m") limit 1000
Everything works fine, except for the fact that it indeed uses the time of the user session, like you stated already. When I try to recreate your solution, I don't get any data as output. While there is in fact a lot of data to be shown. Can you help me?