Fiona Guinee

Hello Tayyab,

Sorry that you are experiencing this issue. Regarding your first point, there could be a number of reasons for this error and I think the most efficient way to troubleshoot would be for you to join an office hours appointment. Is there a time that is convenient for you?

About your second point, I will raise this as a feature request on your behalf.

For users on Seeq version R60 onwards, please use the following formula for lines 5 and 6 in Step 2.

$start_signal = $m.toSignal('Start', startKey()).toString()
$end_signal = $m.toSignal('End', startKey()).toString()

Hello,

Thank you for your question!

To have the latest data at the top of the table you can make use of the sorting functionality.

First, add the start time of the capsule as a column;

Then, click the three dots icon on the start column, and you will be able to sort by descending.

If the table looks too busy then you can modify the header by using the 'Headers' icon and displaying 'None' or a 'Capsule Property', for example.

Please let me know if that helps or if you have any further questions.

Hello Kemi,

Thank you for your question. This chart can be created as follows;

1. Calculate the moving range in the formula tool;

abs($signal.runningDelta())

2. Create the monthly condition using Identify > Periodic Condition tool and select a monthly duration.

3. Use Quantify > Signal from Condition tool to find the average moving range over each month. This is “CL” as shown in the video.

4. In the formula tool, calculate the UCL parameter as follows

3.268*$average_movingrange

Alternatively, create a new Signal from Condition to calculate the standard deviation of the moving average, and in formula use the following;

3*$stddev_movingrange

5. Add the signals to one lane and align their y-axis.

We also have a very comprehensive blog post on creating a Control Chart and applying SPC run rules which may be of interest to you.

Capsule Based Back Prediction or Back-Casting

Scenario: Instead of forecasting data into the future, there may be a need to extrapolate a signal back in time based on data from an event or period of interest. The following steps will allow you to backcast a target signal from every capsule within a condition.

Data

Target Signal – a signal that you would like to backcast.

Event – a condition that encapsulates the event or period of interest from which you would like to backcast the target signal. The target signal must have sufficient sample points within each capsule to create an accurate regression model.

Method

Step 1. Create a new extended event that will combine the capsules from the original event with a prediction window for backcasting. In this example, the prediction window is 1 hr and a maximum capsule duration of 40h is defined.

$prediction_window = $event.beforeStart(1h)
$prediction_window.join($event, 40h)

Step 2. Create a new time since signal that quantifies the time since the beginning of each capsule in the extended event condition. This new signal will be the independent variable in the regression model.

$extended_event.timeSince(1min)

Replace 1min with a sample frequency sufficient for your use case.

Step 3. In formula, use the example below to create a regression model for the target signal, with data from the event as training data, and the time since signal as an independent variable. Assign the regression model coefficients as capsule properties for a new condition called regression condition.

$event.transform($cap->
{$model=$target_signal.validValues().regressionModelOLS( group($cap),false,$time_since,$time_since^2)
$cap
.setProperty('m1',$model.get('coefficient1'))
.setProperty('m2',$model.get('coefficient2'))
.setProperty('c',$model.get('intercept'))})

The formula above creates a second-order polynomial ordinary least squares regression model. The order of the polynomial can be modified (from linear up to 9th) by adding sequential 'timesince^n' statements on line 2 and defining all coefficients as is on lines 4 and 5. See the example below of how to adjust the formula for a third-order polynomial model.

Step 4. Using the regression model coefficients from the regression condition, and the time since signal, the target signal can then be backcast over the prediction window. 

$c = $regression_condition.toSignal('c',durationKey()).aggregate(average(),$extended_event,durationKey())   
$m1 = $regression_condition.toSignal('m1',durationKey()).aggregate(average(),$extended_event,durationKey())    
$m2 = $regression_condition.toSignal('m2',durationKey()).aggregate(average(),$extended_event,durationKey())    

return $m1*$time_since+$m2*$time_since^2 + $c

The example above is for a second-order polynomial and the formula needs to be modified depending on the order of the polynomial defined in Step 3. See the example below for a linear model. Note that it may be required to manually set the units (using setunits() function) of each part of the polynomial equation.

Result

The result is a new signal which backcasts the target signal for the duration of the prediction window prior to the event or period of interest.