cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Business iQ (Analytics)

Query to get time spend in a flow of pages

Torben.Froelund
Creator

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)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
Query to get time spend in a flow of pages
1 REPLY 1
Bob.Bers
AppDynamics Team

Did you experiment with the ADQL series function?