Time Series Expressions

Difference

Description:

The Difference operation creates a Result by calculating the difference between each consecutive value (row) of Input 1. This operation expects the data to be sorted in time order and for each row, subtracts the value above it.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Double
  • Int16
  • Int32
  • Int64

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

DifferencePercent

Description:

The DifferencePercent operation creates a Result by calculating the difference in percentage between each consecutive value (row) of Input 1. This operation expects the data to be sorted in time order and for each row, divides by the value above it.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Double
  • Int16
  • Int32
  • Int64

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

CumulativeMovingAverage

Description:

The CumulativeMovingAverage operation creates a Result by evaluating Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Double
  • Int16
  • Int32
  • Int64

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

SimpleMovingAverage

Description:

The SimpleMovingAverage operation creates a Result by evaluating Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Double
  • Int16
  • Int32
  • Int64

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Double
  • Int16
  • Int32
  • Int64

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

CumulativeMovingMedian

Description:

The CumulativeMovingMedian operation creates a Result by evaluating Input 1.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Double
  • Int16
  • Int32
  • Int64

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal

SimpleMovingMedian

Description:

The SimpleMovingMedian operation creates a Result by evaluating Input 1 and Input 2.

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Double
  • Int16
  • Int32
  • Int64

Input 2
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Decimal
  • Double
  • Int16
  • Int32
  • Int64

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Decimal