Help with RUM Query

ash2 — Sun, 03 Mar 2024 12:13:39 GMT

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

Re: Help with RUM Query

PacoPorro — Mon, 04 Mar 2024 07:45:13 GMT

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

topic Help with RUM Query in DQL

Help with RUM Query

Re: Help with RUM Query