Well, as the documentation shows the fill(previous) should report the value from the previous time interval for time intervals with no data if I made a subquery where I get the status of each VPS for the time range and I use fill previous I would get a consistent serie, but I don’t know why it does not work.
This query:
SELECT last("status") AS "status" FROM "tbh_vps"."autogen"."general" WHERE time > now() - 5m GROUP BY time(30s), "id" FILL(previous)
Returns a matrix of the last 11 states of the VPS on every 30 seconds, but when I try this:
SELECT count("status") FROM (SUBQUERIE) WHERE "status" = 'running' group by time(30s)
It does not work, and I don’t understand why, becouse if I remove the fill(previous) from the subquery the whole statement works as expected.
