topic Re: How to calculate Average of "Response Time", Please help me with query? in DQL

How to calculate Average of "Response Time", Please help me with query?

Dynatracer1218 — Thu, 29 Aug 2024 16:16:58 GMT

Hi,

I am trying to write query to get “Response Time” Average. I am getting Null, when I ran the below query. Can someone please help me on how to calculate the Average of “Response Time”?

Thanks in Advance!

Re: How to calculate Average of "Response Time", Please help me with query?

jaume_reverte — Thu, 29 Aug 2024 16:25:48 GMT

Hello,

For what you are sharing can be that Dynatrace is detecting the value as a String. To check the type use type(ResponseTime) and if it is a String then change it to Number using asNumber(ResponseTime).