# Aggregating Statistics by Grade and Time

## Recommended Posts

FAQ:

I've got a signal for which the average and standard deviation are believed to be drifting over time. When I view the average and standard deviation in calendar time, it isn't helpful because they are highly dependent upon the production grade that I am running. Is there a better way that I could be viewing my data to get a sense of the drift of the average and standard deviation by production grade over time?

Solution 1: Histogram

3. Use the Histogram tool to calculate the average reactor temperature during each grade campaign and display them aggregated over production grade, and time.

The same methods from step 3 can be applied to get a second histogram of the distribution of the standard deviation of the signal of interest by grade over time.

Solution 2: Chain View

2. Use Formula to create a condition for all operating states: \$stateSignal.toCondition()

3. Use the Signal from Condition tool to calculate the average temperature over the all operating states condition.

4. Use the Signal from Condition tool to calculate the standard deviation of temperature over the all operating states condition.

5. Use Formula to calculate two new signals for “Avg + 2 SD” and “Avg – 2 SD”.

6. Filter your all operating states condition for only the state that you are interested in viewing. In this example we want to view only the capsules during which the compressor is in stage 2, for which the syntax is:

\$AllOperatingStates.removeLongerThan(7d).removeShorterThan(4h).filter(\$capsule -> \$capsule.getProperty('Value').isEqualTo('STAGE 2'))

This formula is taking our condition for all operating states, keeping only capsules that are between 4h and 7d in length, then filtering those capsules to include only those for which the value is equal to stage 2.

7. Swap to chain view and view a longer time range.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

×