topic Re: How to convert ms to sec in Open Q&A

How to convert ms to sec?

tarun_kumar_aga — Mon, 19 Sep 2022 09:37:46 GMT

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

Re: How to convert ms to sec

AntonioSousa — Thu, 15 Sep 2022 22:55:26 GMT

@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-with-aggregator/idi-p/153190

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-minutes/m-p/116866

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