paul.roach Posted November 30, 2023 Share Posted November 30, 2023 I am having an issue where seeq will stop providing data until a new value appears or after a certain time period, I have an asset tree set up then I've transferred it to a table. I'm tracking when drains are open, so when the drain is closed the value is 0 which is good and when the drain is open the value is 1. I currently have the scoreboard with red values when the drain is open to indicate things need to be investigated, the only issue I run into is when that value is 1 and seeq stops reading data it will then show a value of 0 which I don't want cause the drain is actually open. I see a lot of formulas filling gaps but what I'm looking for is a formula to keep the last value shown when data is not being updated until new data is received/updated. Link to comment Share on other sites More sharing options...
Seeq Team Solution Chris Harp Posted November 30, 2023 Seeq Team Solution Share Posted November 30, 2023 Hi Paul, In R60+, you can use the resampleHold() function. Here is a link to the Knowledge Base article. https://support.seeq.com/kb/latest/cloud/optimizing-for-infrequently-updating-data If you are using an older version, you can splice a signal that is equal to the last value. $capsule = capsule(now()-7d,now()) $last_value = $signal.toScalars($capsule).last().tosignal() $signal.forecastSplice($last_value) You may need to modify how far back from now in your capsule definition to capture the last signal. 1 Link to comment Share on other sites More sharing options...
paul.roach Posted November 30, 2023 Author Share Posted November 30, 2023 @Chris Harp That's a massive help thank you. Just to clarify, once the data is updated the new value will appear correct? Link to comment Share on other sites More sharing options...
Seeq Team Chris Harp Posted November 30, 2023 Seeq Team Share Posted November 30, 2023 Yes, in both cases, the signal held will be updated to reflect the new data point. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now