Moving Number Calculation

Overview

Moving Number Calculation computes a rolling statistic over the last N input values (number or boolean mapped as 1/0).

Input

Input Type

string

Source value type for the rolling window.

Values:

• number (default) — Number
• boolean — Boolean (true = 1, false = 0)

Input Number

number required

Number fed into the calculation window. Shown when Input Type is number.

Default: 0

Input Boolean

boolean

Boolean fed into the calculation window (true → 1, false → 0). Shown when Input Type is boolean.

Default: false

Amount to Calculate

integer required

Number of previous values to include in the calculation.

Range: 1 to 100000
Default: 10

Calculation Type

string required

Statistic to compute. Note: MODE returns values in Output Array Values. Geometric Mean and Harmonic Mean ignore negative values.

Values:

• MEAN (default) — Mean
• MEDIAN — Median
• MODE — Mode
• MIN — Minimum
• MAX — Maximum
• RANGE — Range
• MIDRANGE — Mid-range (max − min)
• GEOMETRIC — Geometric Mean
• HARMONIC — Harmonic Mean
• RMS — Root Mean Square
• STANDARD_DEVIATION — Standard Deviation
• VARIANCE — Variance
• SUM — Sum
• REGRESSION_CO — Regression Coefficient

Prefill With Value

boolean

If enabled, the calculation window is prefilled with Prefill Value until enough values are collected. For example, if Amount to Calculate is 5 and Prefill Value is 10, the first calculation uses [10, 10, 10, 10, {Input Number}].

Default: false

Prefill Value

number

Value used to prefill the window when Prefill With Value is enabled.

Default: 0

Output

Output Value

number

Result of the moving calculation.

Default: 0

Output Array Values

array

Array of output values used in the calculation (for example for Mode).

Default: []