Help with RUM Query

[ash2]

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

[PacoPorro · Accepted solution]

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