cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Help with RUM Query

ash2
Frequent Guest

Hi Team,

 

I am writing a query to extract a response time of each user actions. The query I tried is as below but it is giving an error at-"(responseEnd - responseStart)"


select distinct name as "User Actions",count(*) as "Requests", (responseEnd - responseStart) as "ResponseTime" FROM useraction WHERE type="Load" GROUP BY name

Is there a better way to extract response time by querying?

Thanks

1 REPLY 1

PacoPorro
Dynatrace Champion
Dynatrace Champion
select DISTINCT(name) as "User Actions",count(*) as "Requests", duration as "ResponseTime" FROM useraction WHERE type="Load" GROUP BY name,duration

Featured Posts