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

[Dynatracer1218]

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!

[jaume_reverte]

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