No State Change in Time Range - Row disapears

[dpunzeng]

Hi there, firstly I am so glad that I found your cool plugin - saved my week!

One issue - or maybe a lack of knowledge/docu:
If I have - say - 5 rows of feed and one row has no state change over the observed time period - IT DISSAPEARS :(

I thought the "expand from query" value solvs this problem by looking further back (enough) to find a state change. But it does not, at least in my setting.
Can anybody poke me in the right direction?
Thx heaps Diet

[dpunzeng]

OK, workaround!
Query that looks fare in the past, to sure find a record, fill it with "null" and do the rest as always. Not sweet but works.
Example:

SELECT "count" FROM
(SELECT (last("firstzone") - last("firstzone")) as "count" from "xxx" WHERE time < (now()-7d)),
(SELECT count("firstzone") FROM "xxx" WHERE ("topic" ='TCS1') AND "firstzone"=2 AND "lastzone"=1 AND $timeFilter GROUP BY time(5m) fill(0))