Sum average duration of three lines

My query is


SELECT average(duration) FROM SyntheticRequest WHERE URL IN (‘one’,‘two’,‘three’) AND monitorName =‘Partner Monitor’ SINCE 3 DAYS AGO COMPARE WITH 1 week AGO TIMESERIES

Is there a way to sum each of these lines and graph just one? So it would be a sum of the average duration of each of the individual three lines into one line. I can only seem to get an average of the three which really skews the graph in places like the 28th and it brings the spike way down. I want that spike but with the added average duration of the red and yellow lines.

Thank you

Hey @bnicholes – Give the following query a try:

SELECT filter(average(duration), WHERE URL='one')
+filter(average(duration), WHERE URL='two')
+filter(average(duration), WHERE URL='three')
FROM SyntheticRequest 
WHERE monitorName ='Partner Monitor' 
SINCE 3 DAYS AGO 
COMPARE WITH 1 week AGO 
TIMESERIES

I think that may be as close as we can get with existing functionality.

Let me know if you have any further questions!

2 Likes