СФ
Переслано от Степа Фомичев...
SELECT sum("AT") as "sum"
FROM (
SELECT (last("startedT") - last("endedT")) as "AT"
FROM "$measurement_name"
WHERE ("transaction" = 'internal'
AND "testId" =~ /^$test_id$/
AND $timeFilter)
GROUP BY time(${aggregation_interval}s), "location"
fill(null))
WHERE $timeFilter
GROUP BY time(${aggregation_interval}s)
FROM (
SELECT (last("startedT") - last("endedT")) as "AT"
FROM "$measurement_name"
WHERE ("transaction" = 'internal'
AND "testId" =~ /^$test_id$/
AND $timeFilter)
GROUP BY time(${aggregation_interval}s), "location"
fill(null))
WHERE $timeFilter
GROUP BY time(${aggregation_interval}s)
