I am using a Value Based Search on a recipe step tag with the condition StepNo >= 3000 AND StepNo <= 5000 to identify cooking periods. Step 7000 is the transfer phase and should not be included. However, the search results appear to extend beyond the cooking phase and display step-change markers for Step 7000. Is there a way to force the result boundaries to stop when the tag leaves the 3000–5000 range, or should I create a formula tag such as CookingPhase = 1 when StepNo is between 3000 and 5000 and search on that instead?
Question
Creating a formula and excluding the outliers
Hi
Your instinct is right: build the formula tag and search on that. A Value-Based Search on the raw StepNo tag bleeds at the boundaries because StepNo is a stepped tag, and the result interval extends to the next sample (the 7000 transition), which is what you're seeing.
Create a binary formula tag for the cooking window:
if(and(StepNo >= 3000, StepNo <= 5000), 1, 0)
Then VBS on CookingPhase = 1 with a small minimum-duration cut. The boundaries will now snap exactly to the 3000–5000 window and Step 7000 drops out entirely.
Kind regards
Frederik
Hi Fvandeal
Thank you for your last insight, i was able to get the binary formula using thisif(and(StepNo >= 3000, StepNo <= 5000), 1, 0) but you made mention of a mall minimum-duration cut. Because it not getting to the end point and the start point of each of the acutual stepNo what can i do?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.