How to convert USQL Ms to seconds

[SachinJindal]

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

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

Thanks

[rgarzon1 · Accepted solution]

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