I've seen some discussions on creating boundaries using periodic conditions. But am interested in seeing if now() can help with creating a relative, rolling window for calculations.
For example, I am trying to create boundaries for temperature signal A (TempA) based on a prediction model for TempA, +/- the standard deviation of the model. Ideally, the StdDev would be calculated continuously over the preceeding 24hrs, offset by 1hr (i.e. the standard deviation of the model between -25h and -1hr).
Right now I've started with this: ($p = prediction model for TempA)
$p.standarddeviation(capsule(now()-25h,now()-1h))
But that yields a constant. And I would like it to continuously calculate over that relative -25hr:-1hr window.
Relative (rolling) calculation window
in General Seeq Discussions
Posted
I've seen some discussions on creating boundaries using periodic conditions. But am interested in seeing if now() can help with creating a relative, rolling window for calculations.
For example, I am trying to create boundaries for temperature signal A (TempA) based on a prediction model for TempA, +/- the standard deviation of the model. Ideally, the StdDev would be calculated continuously over the preceeding 24hrs, offset by 1hr (i.e. the standard deviation of the model between -25h and -1hr).
Right now I've started with this: ($p = prediction model for TempA)
$p.standarddeviation(capsule(now()-25h,now()-1h))
But that yields a constant. And I would like it to continuously calculate over that relative -25hr:-1hr window.