Hi all,
I have a 15 minute timestep data which has random missing values (expected). I’ve managed to track where the data has gaps, but in order to calculate a consistent rolling 24 average of the value I need to fill these missing gaps with a timestep but null value (so i can calculate an average from the preceding X values)
Does anyone have any suggestions on how to fill these data gaps automatically? Or better still calculate a 24 hour rolling average using specific timesteps rather than just number of rows?
Thanks
