Jump to content

Calculated Batch Limit applied as a Scalar

Emily Johnston

Recommended Posts

  • Seeq Team


I want to calculate a limit for my process based on the average of my historical batches. I have calculated the average of each batch using signal from condition, but now I want to take the average of my last several historical batch averages and apply the result to future batches as a scalar in Seeq. 


1) Start with the averages calculated for each campaign:

 Seeq Org Post 1.jpg

2) Add a custom condition for the historical range that you want to use for your calculation:

Seeq Org Post 2.jpg

3) Using signal from condition, calculate the average of the averages over that historical range:

Seeq Org Post 3.jpg

4) Convert the resulting value to a scalar in formula:

Formula is - $avg.toScalars(capsule('2019')).last()

Where $avg is your average of averages, and the Capsule(‘2019’) just needs to contain the year where that sample is placed.

My signal from condition for Average of Averages placed the sample at the start of my historical range condition, so in this formula, I put the year in which my historical range capsule started, 2019.

Seeq Org Post 4.jpg

5) Resulting view of the data outside of the historical range:

Seeq Org Post 5.jpg

  • Like 2
Link to comment
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...