Skip to main content
  • EN

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 

You can create all the timestamps you should have, and merge these with your actual data stream to get a continuous series of timestamps.

 

Thank you this worked perfectly

You're welcome!

Reply


Community Stats

30,108
Posts
114,292
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.