cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to convert USQL Ms to seconds

SachinJindal
Helper

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

 

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

 

Thanks

1 REPLY 1

rgarzon1
Advisor

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 
  • rgarzon1_0-1665027624551.png

 

 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

Featured Posts