from(bucket: "${measurement}")
|> range(start: ${firstTestStartTime}, stop: ${firstTestEndTime})
|> filter(fn: (r) =>
r._measurement == "${measurement}" and
r.location =~ /${location:regex}/
)
|> filter(fn: (r) =>
r._field == "endedT" or
r._field == "startedT"
)
|> aggregateWindow(every: ${aggregation_interval}s, fn: last)
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> map(fn: (r) => ({
_value: (r.startedT - r.endedT), _time:r._time
}))
|> aggregateWindow(every: ${aggregation_interval}s, fn: sum)