InfluxDB+Grafana问题：按时间展示HTTP状态码无法回到基线0

你的问题根源是：当某个时间区间内没有对应状态码的请求时，COUNT()返回的是NULL而非0，Grafana会自动忽略NULL数据点，导致线条直接连接下一个有值的点，而不是降到基线0。

以下是两种可靠的修复方案：

方案1：用SUM()替代COUNT()并补充ELSE 0 #

修改查询语句，将COUNT()换成SUM()，同时在CASE语句中添加ELSE 0，确保没有匹配项时返回0而非NULL：

SELECT $__dateBin(time) AS time,
SUM(CASE WHEN "status" BETWEEN 200 AND 299 THEN 1 ELSE 0 END) AS "2xx",
SUM(CASE WHEN "status" BETWEEN 400 AND 499 THEN 1 ELSE 0 END) AS "4xx",
SUM(CASE WHEN "status" >= 500 THEN 1 ELSE 0 END) AS "5xx"
FROM http_requests
GROUP BY $__dateBin(time)

方案2：保留COUNT()并用COALESCE()转换NULL为0 #

如果更习惯用COUNT()，可以用COALESCE()函数把COUNT()返回的NULL强制转为0：

SELECT $__dateBin(time) AS time,
COALESCE(COUNT(CASE WHEN "status" BETWEEN 200 AND 299 THEN 1 END), 0) AS "2xx",
COALESCE(COUNT(CASE WHEN "status" BETWEEN 400 AND 499 THEN 1 END), 0) AS "4xx",
COALESCE(COUNT(CASE WHEN "status" >= 500 THEN 1 END), 0) AS "5xx"
FROM http_requests
GROUP BY $__dateBin(time)

额外验证：Grafana面板设置 #

如果修改查询后仍有问题，检查图表面板的设置：

• 进入图表的「可视化」选项卡
• 找到「空值处理」（或类似名称）的设置项
• 选择「零填充」或「将空值视为零」，确保Grafana对缺失数据点用0填充

内容的提问来源于stack exchange，提问作者zarathustra