19 Apr 2023
02:26 AM
- last edited on
22 May 2023
02:50 AM
by
Michal_Gebacki
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 .
Solved! Go to Solution.
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.
Featured Posts