Dealing with missing fill data at the begin of a continuous query

,
1

Hi,
I’m using continuous queries to downsample a power measurement. My query looks like this:

CREATE CONTINUOUS QUERY 5m_power ON balancing 
RESAMPLE EVERY 5m FOR 1h 
BEGIN 
  SELECT mean(filled) AS value INTO power_m FROM 
    (SELECT max(value) AS filled FROM balancing WHERE "tag" =~ /Power*/ GROUP BY *, time(1s) fill(previous))
  GROUP BY *, time(5m) 
END

I assume a ‘fill previous’ strategy for the whole data. But it happens that the first 5m bucket of the 1h boundary is wrong, since it is missing the last value from before the boundary to be filled within the first 5m bucket.
To avoid this problem I would like to change the query e.g. in a way that it resamples 1h but only writes the last 55 minutes back INTO power_m, but didn’t find a way that worked.
Any ideas welcome. Thanks in advance, Sebastian

2

@Sebastian_Lorenz.
Thanks for your question. Unfortunately, it’s a feature that just doesn’t exist yet. We’re aware that users like you need it, and I believe it’s in the timeline.