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.