MovingChange

Moving relative change of a freely definable range.

Syntax

 MovingChange(expression, # of data points before)
  • expression: signal expression
  • # of data points before - integer number of points in the signal expression before the current date in the aggregation range

The MovingChange("x" in "unit", # data points before) function calculates the relative difference as fraction of the actual time step value to the previous time step value. This previous value is defined by entering the according number of time steps before. In case of entering zero data points before and after the output is zero.

Example

MovingChange("produced water per time increment" in "STB", 1)

As you see in the following table the MovingChange with 1 data point back in time produces following output based on the 'original signal' as input:

 

Date/Time

 

 

Original Signal

 

MovingDiff
1 datapoint backwards in time

01.02.2007 00:00

-1

1

01.03.2007 00:00

1

1

01.04.2007 00:00

1

1

01.05.2007 00:00

1

1

01.06.2007 00:00

1

1

01.07.2007 00:00

#NULL!

#NULL!

01.08.2007 00:00

1

1

01.09.2007 00:00

-1

1