Jump to content

Combining disconnected discrete data trends using last good values

Recommended Posts


I'm trending a discreet data for about 5 years period from a process unit indicating a valve opening status (1 = close, 2 = Open). When I pulled the plant data using Seeq, I found some periods which I observed "disconnected data" where it will neither shows 1 or 2. Basically, there are gaps in between the data I pulled.

I would like to combined the data together using the last good value before the data got disconnected to the subsequent available data points. May I check if any functions in Seeq I can use to ensure it will always be a continuous single data line?


Much appreciate for the help




Link to comment
Share on other sites

  • Seeq Team

Hi Omar-

I recommend changing the signal to be step interpolated.  This can be achieved through the Formula tool using the following syntax:


The maximum duration of '1d' indicates that Seeq should interpolate between data points spaced by 1 day or less.  When you select a maximum duration, choose a duration that is large enough to interpolate between the gaps in your data, but not so large that it unnecessarily impacts that performance.


Please let me know if you have any additional questions.



  • Like 2
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...