Measure user actions problem: seconds instead of milliseconds

Adrian_Kefirov — Mon, 22 May 2023 09:50:14 GMT

Hello friends,

I create a dashboard to measure the time of all user actions through a user session query:

"SELECT name ,AVG(duration) FROM useraction WHERE (name IS NOT NULL) AND usersession.stringProperties.clienttype="Corporate" GROUP BY name ORDER BY avg(duration) DESC"

Here is one big BUT: all times are in milliseconds and I want to make it in seconds because will be easier for a business .

user actioin 1 - 36,305 ms

user actioin 1 - 10,870 ms

user actioin 1 - 9,865 ms

user actioin 1 - 5,784 ms

user actioin 1 - 5,151 ms

and etc.
I try different ways to convert these milliseconds to seconds but without luck.

Can you give me an idea how to do it?

Re: How to measure a time in seconds not in ms.

rastislav_danis — Wed, 19 Apr 2023 10:44:04 GMT

Division operation (duration/1000 f.e.) is supported, but not with aggregation at this time (error message from UQL: "Mathematical Operation with aggregator functions is not yet supported!"). You can export USQL result (via API https://www.dynatrace.com/support/help/shortlink/api-usql) and convert it externally.

topic Measure user actions problem: seconds instead of milliseconds in Dashboarding

Measure user actions problem: seconds instead of milliseconds

Re: How to measure a time in seconds not in ms.