• To Search the Seeq Knowledgebase:

# Search the Community

Showing results for tags 'average()'.

• ### Search By Tags

Type tags separated by commas.

### Forums

• Community Technical Forums
• Tips & Tricks
• General Seeq Discussions
• Seeq Data Lab
• Seeq Developer Club
• Seeq Admin Forum
• Feature Requests

### Calendars

• Community Calendar

### Categories

• Seeq FAQs
• Online Manual
• General Information

• Published
• Code
• Media

• 0 Replies

• 0 Reviews

• 0 Views

Found 1 result

1. ## guide Selecting Capsules within a Condition

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) The above example shows how to select and perform analysis on one specific capsule in a given time range. If instead you wanted to select a certain capsule of one condition within the capsule of a second condition, you can use the .transform() function. 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: Content Verified DEC2023
×
×
• Create New...