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

How to convert ms to sec?

Hi,

 

I have a requirement to convert from ms to sec .Below is my USQL Query

SELECT avg(visuallyCompleteTime), as "AVG", PERCENTILE(visuallyCompleteTime,10) as 'P10' from user action where name="loading of page *"

 

Please let me know if this is feasible to convert from ms to sec.

 

Thanks,

Tarun

1 REPLY 1

AntonioSousa
DynaMight Guru
DynaMight Guru

@tarun_kumar_aga,

Math operation with aggregator functions is not available in USQL, You can upvote the following Product Idea for it to be more probable in the future:

https://community.dynatrace.com/t5/Dynatrace-product-ideas/RFE-USQL-permit-mathematical-operations-w...

 

There are some places where it is available, but not with aggregator functions:

https://community.dynatrace.com/t5/Dynatrace-Open-Q-A/Get-USQL-duration-results-in-Seconds-or-minute...

https://community.dynatrace.com/t5/Real-User-Monitoring/using-USQL-how-to-show-the-duration-in-Secon...

Antonio Sousa