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

Query to get time spend in a flow of pages

Torben.Froelund
Creator

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

1 REPLY 1

Bob.Bers
AppDynamics Team

Did you experiment with the ADQL series function?

On-Demand Webinarr
Discover new Splunk integrations and AI innovations for Cisco AppDynamics.


Register Now!

Observe and Explore
Dive into our Community Blog for the Latest Insights and Updates!


Read the blog here