Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

Query to get time spend in a flow of pages

Query to get time spend in a flow of pages

We have a shop flow consiting of a number of pages, and I need to track the sum of avg. response time for all pages in flow. E.g. the flow consists of:

Page 1: avg. end use response time of 3 sec.

Page 2: 4 sec.

Page 3: 2 sec.

So total time for flow is 9 sec. I need to make a times series graphs which shows how this total develops over time.

I can get average for all pages in scope with this query, but can find out how to get the sum of all pages:

 

SELECT pagename, avg(metrics.`End User Response Time (ms)`) FROM browser_records WHERE pagename IN ("www.telenor.dk/shop/mobil","www.telenor.dk/shop/mobiler","www.telenor.dk/shop/kurv")

 

Any help would be highly appreciated, thanks :)

Tags (2)
Query to get time spend in a flow of pages
1 REPLY 1
AppDynamics Team

Re: Query to get time spend in a flow of pages

Did you experiment with the ADQL series function?