How to convert ms to sec?

[tarun_kumar_aga]

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

[AntonioSousa · Accepted solution]

@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...