Thank you this is helpful. But I’m sorry I’m still confused.
The goal with my query above wasn’t to show the source data but to show a table like the screen shot you just shared, once you have null values. And then the flux i shared above lets you fill the values if the gap is small and not fill them if the gap is large or stale (i.e. there is no reliable data after the threshold period so the fill function should not fill windows with stale values)
Can you please help me by using array.from() to share some dummy input data (maybe at the point of the screenshot you shared) and some example output data?
I’m going to loop in @scott because I’m feeling dense. I’m not sure what I’m missing here.
