davidkohn88

This is really cool, I just started looking at it and it seems really interesting in terms of its approach as well as something that could be innovative for our...

This isn't possible, but you can create the continuous aggregate using the normal time bucket and then do time_bucket_gapfill when you query the view, this should pretty closely approximate what...

I didn't see the previous comment until now, but I will also say that the join, if structured correctly (as a lateral with order by time desc limit 1, and...

Thanks for the request! I think the plan here is to have some sort of window function that provides lookback and bounding capability so that you can do this a...

Hi! Have you looked at https://docs.timescale.com/latest/api#time_bucket_gapfill? I think `time_bucket_gapfill` in a subquery followed by a `count(*) filter (where power is null)` + `count(*)` should give you the ratios you want?...