Sharing something with you all. See if there is better way to do this, pls chime in and let me know
I was trying to investigate how to get (FrontEnd ,Server, Network) time for one of our critical trx and see a high level picture. We live in AWS & wanted to see the network time impact on our overall latency .
select DATETIME(usersession.startTime, 'HH:mm - MM/dd', '60m'), MEDIAN(frontendTime) , MEDIAN(servertime), MEDIAN(networktime) from useraction WHERE useraction.name IN ("TRXName") AND usersession.browserFamily IN ("Chrome")
GROUP BY DATETIME(usersession.startTime, 'HH:mm - MM/dd', '60m').
This allowed us to see the impact of netwok and how it can trigger latency for your app.
i used median instead of average. Hope this helps & if there is a better way to see the impact of network on your app, do let me know pls.
This is a good USQL, but depending on your need,
If you need the median or the AVERAGE because its not the same meaningful.