Jump to content

Recommended Posts

  • Seeq Team

In some cases you may want to do a calculation (such as an average) for a specific capsule within a condition. In Seeq Formula, the toGroup() function can be used to get a group of capsules from a condition (over a user-specified time period). The pick() function can then be used to select a specific capsule from the group. The Formula example below illustrates calculating an average temperature for a specific capsule in a high temperature condition. 

// Calculate the average temperature during a user selected capsule of a high temperature
// condition. (The high temperature condition ($HighT) was created using the Value Search tool.)
//
// To prevent an unbounded search for the capsules, must define the search start/end to use in toGroup().
// Here, $capsule simply defines a search time period and does not refer to any specific capsules in the $HighT condition.
$capsule = capsule('2019-06-19T09:00Z','2019-07-07T12:00Z')
 
// Pick the 3rd capsule of the $HighT condition during the $capsule time period.
// We must specify capsule boundary behavior (Intersect, EnclosedBy, etc.) to 
// define which $HighTcapsules are used and what their boundaries are (see 
// CapsuleBoundary documentation within the Formula tool for more information). 
$SelectedCapsule = $HighT.toGroup($capsule,CapsuleBoundary.EnclosedBy).pick(3)
 
// Calculate the temperature average during the selected capsule.
$Temperature.average($SelectedCapsule)

 

Edited by John Cox
  • Like 1
Link to post
Share on other sites
  • 1 year later...

Here's another method to pick a specific capsule within a condition. In this example, the user want to pick the first capsule from condition 2 within condition 1.

Use formula tool:

$condition1
.removeLongerThan(1d)
.transform($c -> 
           $condition2.removeLongerThan(1d).toGroup($c).pick(1))

The output:

 

image.thumb.png.8d6c5720ba47776d2ebb924763b89d8c.png

 

Edited by Nuraisyah Rosli
Link to post
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...