Jump to content

John Cox

Seeq Team
  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by John Cox

  1. Accurate data alignment can be the most challenging part of creating process calculations, finding correlations, and developing prediction models. It is an often overlooked data cleansing step that may be even more critical than smoothing noisy signals and removing data outliers. The need for data alignment stems from time delays present in the industrial process (related to physical transport and equipment/piping volumes, as well as lab measured data reported well after process operation completes). Another common data alignment need centers on comparing process metrics before/after process events of interest, which again involves time delays (or time shifts). 

    There are at least four categories of data alignment use cases prevalent across the process manufacturing industries:

    1. Known time delay - The time delay resulting from the transportation of material at a given speed or velocity (across some distance in the process operation) can mask strong correlations between upstream/downstream signals or other signals separated in time, resulting in poor modeling results if not accounted for by a data alignment step.
    2. Variable time delay – Here the time delay is variable and a function of production speed, storage volumes, etc. but can be calculated based on measured/known process parameters.
    3. Before/after comparisons - Related to process experimentation and optimization, there is a recurring need to calculate and compare process metrics before and after some identified process event, such as a process feed being turned on, a unit restart, equipment maintenance, a process parameter or setpoint being adjusted, etc.
    4. Process and analytical (LIMS) data - When trying to correlate process signals with lab-measured analytical results, work is often needed to align the process signals and subsequent analytical results. In some cases, the alignment can be based on sequential, consistently reported lab data values. In other cases, more sophisticated logic, such as connecting process operation and lab results by matching id properties, is needed.

    Example methods for addressing each of these cases, using Seeq tools and Formula, are included below.


    Use Case Category #1: Known Time Delay

    In this specific example, the goal is to correlate a process signal (temperature) with a later reported lab result, but this use case also occurs frequently with continuous upstream (earlier in the process) and downstream signals (later in process), and the same time shifting methodology applies. 

    It is known that the lab result is consistently reported 2 hours after the process operation which would most correlate. Therefore, the “Process Temperature” signal needs to be shifted 2 hours to the right in time and then sampled for each unique “Lab Measured Analytical Result” value.

    U1 Raw Data.JPG


    Analysis Steps

    1. We shift the raw "Process Temperature" 2 hours to the right using Seeq Formula's move() function to create "Temperature Shifted 2 Hours to Right":


    U1 Step1.JPG


    2. We use Seeq Formula's resample() function to pick off values of the shifted temperature at the exact timestamp that new "Lab Measured Analytical Result" values are reported. The resample() function gives the ability to sample one signal based on the timestamps of the data values from another signal. The result is 1 temperature sample (green, Lane 1) per lab sample (Lane 2). 


    U1 Step2.JPG

    3. The value of the data alignment is obvious by comparing two XY plots of the lab result and the original, raw temperature/aligned temperature. The correlation between the process temperature and the lab result, hidden in the XY plot on the left, is obvious in the XY plot on the right, which shows the aligned temperature:

    U1 XY1.JPGU1 XY2.JPG



    Use Case Category #2: Variable Time Delay

    This use case is similar to the previous: correlating two measurements separated by a time delay, but with an additional complication. Here, the time delay is variable and is based on the physics of a material transport distance: changes in an upstream pressure physically take many hours to work their way through equipment/piping and influence a downstream analyzer signal. The physical time delay varies based on Production Line Speed. 

    U2 Raw Data.JPG


    Analysis Steps

    1. The transport distance is known (500 feet) and set up as a value using Seeq Formula. The user calculates the Time Delay between the 2 signals based on the Transport Distance / Production Line Speed. The resulting time delay fluctuates between 7 and 13 hours. 

    Transport Distance Formula:


    Calculated Time Delay Formula:


    U2 S1.JPG


    2. Using Seeq Formula's move() function, the Upstream Pressure can then be shifted (by the variable time delay calculated in Step 1) so that the effect of pressures changes upstream aligns in time with the resulting impact on the Downstream Analyzer.

    // Limit the maximum time delay to 20 hours

    Changes in the upstream pressure (yellow signal) are now correctly aligned in time with their effect on the downstream analyzer (blue signal): 

    U2 S2.JPG

    Note that in this use case, we did not need to use the resample() function as we did with the discretely measured lab data in Use Case Category #1, as here we are working with continuously measured signals. 


    Use Case Category #3: Before/After Comparisons

    An extremely common use case is to compare process metrics before/after some process event. The process event could be anything of interest: a process unit restart, equipment or control strategy modifications, periodic maintenance work, process experimentation, etc. The analysis begins by identifying the process events and then calculating the metrics over appropriate time ranges before and after each event. The alignment step typically involves creating a common time basis spanning before/after operation and moving the before/after calculated metrics to the same point in time for comparison.

    Analysis Steps

    1. For this example we begin with a Pressure signal that ramps up over time as equipment run life increases and the equipment fouls. The equipment is shut down for Maintenance periodically and the process then restarts at a much lower pressure value. We use the Pressure signal and Seeq Formula to identify Equipment Maintenance periods based on the running delta of the pressure signal < 0:


    U2 Step1.JPG


    2. Use Formula's grow() function to expand Equipment Maintenance to create a Before and After Maintenance time period which includes the desired time period (for example, 4 hrs) for calculating before/after pressures. This also gives a common time basis for a later alignment step. 


    Results are shown here in Chain View for the Before and After Maintenance capsules, which gives a nice visual of the pressure 4 hours before and after maintenance. 

    U3 S2.JPG


    3. Average the Pressure signal over the first 2 hours of the Before and After Maintenance capsules.

    // Do a 2 hour avg pressure over the FIRST 2 hours
    // of the Before and After Maintenance capsules

    U3 S3.JPG


    4. Use Signal from Condition to align the average pressure before maintenance (Step 3) at the middle of the Before and After Maintenance capsules. Signal from Condition is commonly used to find a value within a condition and move it to a specific location in time. In this case, we can use the Maximum statistic to find the correct "Pressure Avg (Before)" value, as there is only 1 value for each maintenance capsule. Using Signal from Condition in this way is a key technique for aligning before/after process values/metrics. 

    U3 S4 SFC.JPG


    We can see that the "Pressure Avg (Before)" has now been moved to the middle of the "Before and After Maintenance" capsules:

    U3 S4.JPG


    5. Repeat steps 3 and 4 to compute/align the average pressure after maintenance, and then move/align to the middle of the Before and After Maintenance capsules. 

    U3 S5.JPG


    6. With the before/after pressure values aligned in time, we now use Formula to calculate the percent pressure reduction resulting from maintenance.

    // Calculate the % change relative to the
    // the Pressure Avg (Before)

    U3 S6.JPG



    Use Case Category #4: Process and Analytical (LIMS) Data

    In this example, we will align calculated process metric values from each batch (e.g., max temperature, total Chemical A flow added) with later reported lab results (often referred to as LIMS - Laboratory Information Management System data).This is a very common analytics need.

    Here, the “Product Impurity” lab results are reported at varying time intervals following batch completion, so a constant time delay alignment approach isn’t feasible. 

    U4 Raw Data.JPG


    Zooming in, we can confirm that the lab results are reported (step to a new value) some time after the Process Batches complete. The reporting time is variable.

    U4 Raw 2.JPG


    Analysis Steps

    1. The maximum temperature and totalized chemical added over each Process Batch are thought to correlate with (influence) the amount of final Product Impurity. So, we need to calculate the max T and total chemical A added per Process Batches capsule. Use Signal for Condition to do the calculations and place results at the end of each Process Batch. 

    U4 S1 2.JPG   U4 S1 3.JPG

    U4 S1.JPG


    2. We now need to work on alignment. To provide a basis for joining the process results to the corresponding lab results, we need to create "Product Impurity Results Capsules" for every value change in the reported Product Impurity. We use the Formula toCondition() function for this and store the numeric lab result in a capsule property named PctImpurity. 


    Note: in the screenshot below, the highlighted Product Impurity Results capsule contains the lab result for the Process Batches capsule at the top left of the screen. 

    U4 S2.JPG


    3. Now, use Composite Condition to "join" the Process Batches condition to the Product Impurity Results Capsules condition, so we have a time period that contains the process and lab results we want to align and correlate. We check the Inclusive options to create capsules from the start of Process Batches to the end of Product Impurity Results Capsules:

    U4 S3 2.JPG

    The resulting yellow "joined" capsules in the screenshot below now span the time period of process operation and the eventual lab measured impurity result, for each individual batch. 

    U4 S3.JPG


    Investigating a zoomed time period, we can see the Process Batches start joined to the end of the resulting Product Impurity Results Capsules. 

    U4 S3 3.JPG


    4. With a common capsule established, we align Max T, Total Chemical A, and Product Impurity at the middle of the "Process Batches to Impurity Result (joined)" capsules. For Max T and Total Chemical A, we use the 'Value at Start', and for Product Impurity, we use the 'Value at End'. Using Signal from Condition in this way is a key technique used in aligning process and lab data values. 

    U4 S4 2.JPGU4 S4 3.JPGU4 S4 4.JPG


    The results for a short time period look like this, and the "aligned" values can be used for further calculations or for creating a prediction model to predict Product Impurity based on Max T and Total Chemical A:

    U4 S4.JPG


    Joining Process and Lab Values Based on a Matching Capsule Property

    With that example finished, let’s look at another common (and more complicated) scenario in this use case category: when analytical results can be reported inconsistently or out of sequence with process batches, a more advanced condition join using Seeq Formula, based on a matching id or other capsule property value, may be needed.

    In this example, a numeric batch id is a capsule property shared by the Process Batches and Lab Analytical Batches conditions: see the 437 and 438 capsule property values shown as labels on the blue and green capsules in the screenshot below. Using this batch id linkage, matching id Process/Lab capsules can be joined with a single line formula, and capsule properties from the separate process and lab conditions (e.g., see the 0.99 and 1.32 lab product impurity results shown on the blue capsules) can be preserved, all courtesy of enhanced “capsule matching by property” functionality introduced in Seeq R56 (link). 

    Starting with the raw data and Process Batches and Lab Analytical Batches conditions and their capsule properties, we have already calculated the "Average Process Ratio for Batch" using Signal from Condition and located it at the start of the Process Batches capsules. We illustrate only the critical steps in this use case under Analysis Steps below: 

    U4 Adv 1.JPG


    Analysis Steps - Joining Process and Lab Data on a Matching Capsule Property

    1. We join the Process Batches (capsules) to Lab Analytical Batches, based on their BatchID/LabID property matching. We use the join() Formula function. The batch id numeric is stored as the "LabID" capsule property in the Lab Batches condition, so, prior to doing the join, we must rename it to have the same property name as the "BatchID" capsule property on the Process Batches condition. Note: the capsule property matching and keepProperties() are enhanced functionality options introduced in Seeq R56. 

    // Join process to lab batches based on matching ID.
    // We need to rename the LabID capsule property to BatchID for the
    // lab capsules. 
    // Use keepProperties() so that the resulting condition has
    // the Result capsule property (the lab measured product impurity value). 
    $ProcessBatches.join($LabBatches.renameProperty('LabID','BatchID'), 4d,
      true, 'BatchId',

    Inspecting the capsules and the batch id and product impurity capsule property values at the top of the trend, we see the "Process Batches Joined" capsules are linked based on matching ID, and the product impurity "Result" capsule property (the 0.99 and 1.32 values) is retained and now part of a capsule that starts at the beginning of each Process Batches capsule:

    U4 Adv 2.JPG


    2. We now translate the "Process Batches Joined to Lab Batches on ID Match" Result capsule property into a "Lab Measured Product Impurity Aligned to Batch Start" signal, with values moved to the start of the Process Batches, at the exact location we have the Avg Process Ratio for Batch. 


    For this short time range, we can confirm the 0.99 value for the resulting impurity signal aligns correctly to BatchID 437, and the 1.32 value aligns correctly to Batch 438. 

    U4 Adv 3.JPG


    As a result, we have now connected the lab measured product impurity result to each individual process batch, regardless of lab result timing, and with additional steps have aligned the Average Process Ratio and Lab Measured Product Impurity.



  2. A common industrial use case is to select the highest or lowest signal value among several similar measurements. One example is identifying the highest temperature in a reactor or distillation column containing many temperature signals. One of many situations where this is useful is in identifying the current "hot spot" location to analyze catalyst deactivation/performance degradation. 

    When selecting the highest value over time among many signals, Seeq's max() Formula function makes this easy. Likewise, if selecting the lowest value, the min() Formula function can be used. A more challenging use case is to select the 2nd highest, 3rd highest, etc., among a set of signals. 

    There are several approaches to do this using Seeq Formula and there may be caveats with each one. I will demonstrate one approach below. 

    For our example, we will use a set of 4 temperature signals (T100, T200, T300, T400). Viewing the raw temperature data:



    1. We first convert each of the raw temperature signals to step interpolated signals, and then resample the signals based on the sample values of a chosen reference signal that has representative, regular data samples (in this case, T100). This makes the later formulas a little simpler overall and provides slightly cleaner results when signal values cross each other. 

    For the T100 step signal Formula:


    Note that the T200 step signal Formula includes a resample based on using 'T100 Step' as a reference signal:


    The 'T300 Step' and 'T400 Step' formulas are identical to that for T200 Step, with the  raw T signals substituted. 


    2. We now create the "Highest T Value" signal using the max() function and the step version T signals: 



    3. To create the '2nd Highest T Value' signal, we use the splice() function to insert 0 values where a given T signal is equal to the 'Highest T Value'. Following this, the max() function can again be used but this time will select the 2nd highest value:



    4. The process is repeated to find the '3rd Highest T Value', with a very similar formula, but substituting in values of 0 where a given T signal is >= the '2nd Highest Value':



    The result is now checked for a time period where there are several transitions of the T signal ordering:



    5. The user may also want to create a signal which identifies the highest value temperature signal NAME at any given point in time, for trending, display in tables, etc. We again make use of the splice() function, to insert the corresponding signal name when that signal is equal to the 'Highest T Value':



    Similarly, the '2nd Highest T Sensor' is created, but using the '2nd Highest T Value':


    (The '3rd Highest T Sensor' is created similarly.)

    We now have correctly identified values and sensor names... highest, 2nd highest, 3rd highest:


    This approach (again, one possible approach of several) can be extended to as many signals as needed, can be adapted for finding low values instead of high values, can be used for additional calculations, etc. 


    • Like 2
  3. Hi Chase,

    Teddy has a great suggestion above on using Seeq's OData export.

    I also wanted to mention another option for your consideration: creating an Add-on tool in Seeq Workbench that has a button the operators click to pull the data. Seeq Add-ons use the Seeq Python Library module (SPy) with Seeq Data Lab. Add-ons can easily pull data into the Data Lab environment and create custom visualizations, calculations, charts, etc. using any Python library functionality, and all of this can be accessed from Seeq Workbench. This may or may not be a way to address your current need, but even if not, it may be a good solution for other applications in the future. 

    There is a Seeq Add-on Gallery here: https://seeq12.github.io/gallery/

    The following links provide additional information on how to create your own add-ons or install the open source add-ons:




  4. Hi,

    Currently you can add a capsule property to a condition type table without using the New Metric, by using the Row or Column buttons. But, while you do have filtering and sorting capabilities on these capsule properties in the table, this doesn't give you the ability to color code the table cells for that property (New Metric with thresholds is needed for that). 

    So yes, currently you would need to convert the capsule property to a signal first. 

    There is a new feature request in our development system to do exactly what you want, so this may be added in the future.


  5. The details and approach will vary depending on exactly where you are starting from, but here is one approach that will show some of the key things you may need.

    When you say you have 3 capsules active at any given time, I assume you mean 3 separate conditions. Assuming that is the case, you can create a "combined condition" out of all 9 conditions using Seeq Formula:

    // Assign meaningful text to a new capsule property

    // named TableDesription

    $c1 = $condition1.setProperty('TableDescription','High Temperature') 

    $c2 = $condition2.setProperty('TableDescription','Low Pressure')

    and so forth...

    $c9 = $condition9.setProperty('TableDescription','Low Flow')

    // Create a capsule that starts 5 minutes from the current time
    $NowCapsule = past().inverse().move(-5min)
    // Combine and keep only the currently active capsules (touching "now")


    You can then go to Table View, and click the Condition table type. Select your "combined condition" in the Details Pane and add a capsule property (TableDescription) using the Column or Row button at the top of the display.

    You can then set your display time range to include the current time, and you should see the currently active capsules with the TableDescription text that you assigned in the Formula.

    You of course will want to vary the "-5min" value and the 'TableDescription' values per what is best for you. 

    Your approach may be a little different depending on where you are starting from, but I think that creating capsule properties (text you want to see in your final table), combining into one condition, and using .touches($NowCapsule), may all be things you will need in your approach.

    Here are some screenshots from an example I put together, where I used "Stage" for the capsule property name: 


    • Like 1
  6. Hello Siang,

    Currently, simple type scorecard metrics can't be used in Seeq Formula. We have recently added some functionality for using condition type scorecard metrics in Formula, but that will not help you in this use case.

    Your request to get a display range capsule is a good one and is already on our feature request list for our development team.

    For now, your best method is to create a Manual Condition, and add a capsule to the Manual Condition that is your current display range, to create a Display Range Condition. You can then use the Display Range Condition with Signal from Condition to calculate a signal representing the average (or other desired statistics) over the display range. That signal can be used in additional Formulas and calculations. 

    When you want to change your analysis to a new display range, you will of course need to take one extra step to edit the Manual Condition and update it to match the current display range. 


  7. Hi Bayden,

    I would try something like this in Seeq Formula, on the signals that change infrequently:


    In place of the "30d" you would enter the maximum time that you want to connect data points and to see the lines drawn. Given you are working with setpoints, I would recommend converting them to step interpolation using .toStep(). 

    If that doesn't get you to the final result that you want, you can add one further function:


    The resample will add more frequent data values at the period you specify (change the "1d" to whatever works best for you). You do need to be careful that you aren't adding any incorrect or misleading values with this approach, based on your knowledge of the signals.

    Let us know if this helps. I believe you can get a solution you are happy with.



    • Thanks 1
  8. Hello Filip,

    When you want to add data to an already existing signal, you will want to find your original imported file in the Seeq Data tab, and click the edit button (circled in red below):


    You will then be able to drag a new file for import, and you will notice that you now have Replace and Append options (see an example I did below):



    You can choose to replace or append. I think this will solve your problem. If it does not, please let me know. Some additional information on adding new data to an existing imported signal can be found here in our Knowledge Base: Knowledge Base: CSV Import Replace and Append




  9. Hi Robin,

    1) To answer your earlier question, to avoid the time weighted standard deviation, all you need to do is change the signal to a discrete signal and then apply the same formula: 

    .aggregate(stdDev(),                                                         // std deviation statistic
    periods(10min,1min).inside($CanProductionCapsules), // do the calc over 10 min rolling window every minute
                                                                                               // but only for 10 minute capsules fully inside CanProduction capsules
    endKey()                        // place the calculation result at the end of the 10 minute window
    , 0s)                               // max interpolation between data points, use 0s if you want discrete result 


    2) To answer your most recent question, to convert your current result to a stepped signal rather than the discrete results you now have on the trend, you can use a Formula function named .toStep(). Inside the parentheses, you enter the maximum amount of interpolation, the maximum amount of time you want to draw a line connecting your calculated results. For example, the function below sets a maximum interpolation between data points of 8 hours. 


    Hope this helps!


  10. Hello Mohammed,

    The answer depends on exactly what you want to remove from the signal. In some cases, you may want to do a Value Search to find the peaks you want to remove, then use the .remove() function in Seeq Formula to create the new signal with the peaks removed. In some cases, all you may need is to apply a smoothing filter (for example, agileFilter() in Seeq Formula or one of the Signal Smoothing options under the Cleanse Tools), or perhaps use removeOutliers() in Seeq Formula. The documentation below provides a great summary of the many data cleansing tools in Seeq. I hope this information is what you are looking for!


  11. I do not have access to your original signal for testing, so my solution not handle all the unusual characteristics that may occur. But I believe the approach below will help you get going on this calculation.

    1. I would first recommend you create a clean weight signal that uses the remove() function to eliminate small decreases in the weight signal due to measurement noise and equipment variation. (This first step makes step 2 work accurately, because in step 2 we will be looking for the weight to go above 2000, 3000, 4000, etc., and we don't want noise variation from say 3002 lb to 2999 lb at the next sample, to appear to be a step decrease.)

    Create a clean weight signal using the formula below. This should result in a weight signal that only increases during the normal rampups, but still resets to 0 when the next rampup processing begins. Note that the 1hr inside of toStep() is the maximum interpolation between data values; set this based on your preferences. 



    2. Create the Step Counting Signal by dividing the clean weight (step 1 result) by 1000 and using the floor function to generate an integer result.




    3. For an example signal that I tested with, you can see the Step Counting Signal incrementing as each 1000 lb increment is exceeded. Depending on your final analysis goals, further calculations could of course be done to calculate/report the number of steps completed for each of your original purple capsules or to do other types of statistics. 




  12. Hi Robin,

    I would use a Seeq formula similar to the one below, with the Can Weight signal and your existing Can Production capsules as inputs. The key functions used are aggregate(), periods(), and inside(). Note that you could also do the std deviation calculation using Signal from Condition, using a condition created in Formula with: periods(10min,1min).inside($CanProductionCapsules).

    .aggregate(stdDev(),                                                         // std deviation statistic
    periods(10min,1min).inside($CanProductionCapsules), // do the calc over 10 min rolling window every minute
                                                                                               // but only for 10 minute capsules fully inside CanProduction capsules
    endKey()                        // place the calculation result at the end of the 10 minute window
    , 0s)                               // max interpolation between data points, use 0s if you want discrete result 

    Hope this helps!


  13. As another variation, in some cases the user may want to see the number of overlapping capsules at any point in time. In this case, the .fragment() Formula function may be helpful:


    The .fragment() function creates a non-overlapping condition representing all the boundaries of capsules in an overlapping condition. 

    You can see a comparison of the conditions generated using .merge() and .fragment() below. Where there are overlapping capsules, the .fragment() function creates a series of capsules touching each other. For example, note that there are 5 green capsules in the Event Condition (fragment) shown on the far right of the trend. 



    • Like 1
  14. FAQ: How do I identify time periods where I have overlapping capsules within the same condition? I may want to keep only the capsules (time periods) where capsules overlap. I may also want to keep the times where a certain number (2, 3, or more) of capsules overlap. In this example, we will find time periods where there are at least 2 overlapping capsules which make up the Event Condition. In the screenshot below, you can see there are 3 separate time periods where the Event condition capsules overlap:



    Step 1: Merge any overlapping capsules together using the merge() function in Formula:


    Now, we have a time period basis (Event Condition (merged)) over which we can count the total number of overlapping capsules.


    Step 2: Count the number of overlapping capsules using the count of the original Event Condition capsules over each Event Condition (merged) capsule:


    This creates a new signal as shown in the trend below. We can see that the new signal values (where > 1) correctly identify the 3 time periods where there are overlapping capsules in the original Event Condition.



    Step 3: We use Formula to find where the Event Condition (merged) capsules touch a time period where the Number of Overlapping Events signal (created in Step 2) is > 1. Note that we could test for varying number of overlapping capsules (> 2, > 3, etc.) depending on the goals of our analysis. We could also break Step 3 into 2 steps (a Value Search to find where the Number of Overlapping Events is > 1, followed by a Composite Condition to do the touches logic). 




    This generates the final results where the Overlapping Events condition correctly identifies our time periods of interest:


    • Like 2
  15. Hi Steve,

    As a follow-up to your "ability to do a first order filter in Seeq" question from earlier this year, I wanted to mention that the latest version of Seeq (R50) now includes an exponentialFilter() function in the Formula tool. This new function does the first order filter (or first order lag response) that you are interested in. You can see an example below where 3 first order filters were created with different tau values, to filter the raw signal. If you need any help testing this out, don't hesitate to let us know!



    • Like 2
  16. A common analytics need is to calculate changes in a signal's value over different time periods (such as hourly or daily). One example is calculating the change in a tank level signal as a way to infer flow rates, production, amount transferred, etc. While the Seeq Formula derivative() function is often useful in these situations, in some cases the user may want to simply calculate the signal change over a specified time period (perhaps once/hour). 

    While there are many ways to do this in Seeq, two efficient ways are: 1) using the Delta statistic in Signal from Condition and 2) using $signal-$signal.delay() in Formula. 

    Here is an example to illustrate:

    We have a tank level signal shown in lane 1 and we have calculated the hourly change in the tank level by two different methods (the results are shown in lane 2):



    The first method to calculate the level change per hour uses an Hourly condition (created using the Periodic Condition tool to generate the green capsules). Then, Signal from Condition is used to generate the Hourly Level Change (Signal from Condition) in lane 2, by selecting the Delta statistic over the Hourly bounding condition:



    The second method uses the delay() function in Formula, subtracting the one hour delayed level from the current value of the level signal. This generates the Hourly Level Change (Formula Delay Function) in lane 2



    Note that this approach creates an hourly level difference for each sample point, where the first approach generates a level difference result once per hour.

    Also note that the user could choose to filter (smooth) the level signal and then apply the level difference calculations, if they desire a more smoothed calculation result. There are several filtering options in Seeq. The agileFilter() function would work well for the level signal in the example.


  17. 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.


    • Like 2
  18. I have created a daily condition in Seeq using the Periodic Condition tool. Why don't the capsules start at midnight?

    For example, in the screenshot below the "Daily" capsules start at 11:00PM (see the Capsules pane) instead of midnight (12:00AM). This results when the user interface (UI) time zone does not match that of the Seeq Server. In this example the Seeq Server time zone is US/Eastern but the UI time zone is US/Central. To make the UI time zone match, the user can click on the UI time zone link (noted by the red box in the screenshot: trend display, x-axis, right of timestamp): 



    The user can then set the "Always use:" option to US/Eastern (in this example the Seeq Server is on US/Eastern) as shown here:



    The daily capsules now start at midnight:


  19. A common analytics need is to create a signal with numerical values that are based on an existing condition. Users often want to translate a condition (on/off, good data/bad data, running/down, etc.) to a numerical value to be used in calculations. For example, a user may want to multiply a process signal by a 0/1 value based on when the process is down/running. This technique can also be used to replicate "if" logic or "if / else" logic, where different values are returned depending on if the condition is true/false. 

    Converting a condition to a signal value can be easily accomplished in Seeq using the Formula Tool and the splice function. Here is an example where we convert a condition to a signal of 0s and 1s:


    1. Use the Value Search Tool to create a HOT condition for time periods when the Temperature signal is > 90 degrees F:



    2. Use the Formula Tool to convert the HOT condition to a 1 (when condition is true) and a 0 (when condition is false):



    3. View the results in the trend. The new signal in lane 2 has a value of 1 when the HOT condition is true. Otherwise the signal is 0.



    Additional Information

    Using Conditions and the Splice Function to Replace If Statements



    • Like 1
  • Create New...