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