您应该能够在没有子查询的情况下完成此操作。首先尝试这样的方法,以确保count和countError符合您的预期:
SELECT sum("count"),sum("countError") FROM "$measurement_name" WHERE "transaction" = 'all' AND "application" =~ /^$application$/ AND $timeFilter GROUP BY time($__interval) fill(null)
然后,您可以发出单个查询来划分它们:
SELECT sum("count")/sum("countError") FROM "$measurement_name" WHERE "transaction" = 'all' AND "application" =~ /^$application$/ AND $timeFilter GROUP BY time($__interval) fill(null)