How to convert USQL Ms to seconds

SachinJindal — Wed, 05 Oct 2022 22:57:47 GMT

SELECT avg(useraction.visuallyCompleteTime) as "AVG", PERCENTILE(useraction.visuallyCompleteTime, 80) AS "80th" ..............

How Avg/80th percentile can be changed from ms to sec

Thanks

Re: How to convert USQL Ms to seconds

rgarzon1 — Thu, 06 Oct 2022 03:47:07 GMT

hi SachinJindal

in short, you cannot.

if you try to divide by 1000 you will allways get: Mathematical Operation with aggregator functions is not yet supported!
if you try to group by, when you take the value divide by 1000 and 60 'visuallyCompleteTime/1000/60' you will get the same problem but with group.

you can allways use the data explorer

and by last but not least important you can allways use PowerUps, doing a !PU(link):visuallcomplete, and next using this in another tile to make it work.

Have Fun

topic How to convert USQL Ms to seconds in Real User Monitoring

How to convert USQL Ms to seconds

Re: How to convert USQL Ms to seconds