Single Variable Statistics

ArithmeticMean

Description:

The ArithmeticMean operation creates a Result by computing the arithmetic mean of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

GeometricMean

Description:

The GeometricMean operation creates a Result by computing the geometric mean of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

Median

Description:

The Median operation creates a Result by computing the median of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

Mode

Description:

The Mode operation creates a Result by computing the mode of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

Variance

Description:

The Variance operation creates a Result by computing the variance of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

StandardDeviation

Description:

The StandardDeviation operation creates a Result by computing the standard deviation of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

Skewness

Description:

The Skewness operation creates a Result by computing the skewness of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

Sum

Description:

The Sum operation creates a Result by computing the sum of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

Min

Description:

The Min operation creates a Result by computing the minimum value of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

Max

Description:

The Max operation creates a Result by computing the maximum value of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

Count

Description:

The Count operation creates a Result by computing the count of values in Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Any

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

CountUnique

Description:

The CountUnique operation creates a Result by computing the count of unique values in Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Any

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Int32

Product

Description:

The Product operation creates a Result by computing the product of all values inInput 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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

FirstItem

Description:

The FirstItem operation creates a Result by taking the first value of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Any

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Any

LastItem

Description:

The LastItem operation creates a Result by taking the last value of Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

Input 1
Input Types:

  • Data Point
  • Literal
  • Variable
  • Stack

Data Types:

  • Any

Result
Input Types:

  • Data Point
  • Variable
  • Stack

Data Types:

  • Any

Range

Description:

The Range operation creates a Result by computing the range of values in Input 1.

If Input 1 is a HyperCube Measure, the Result must be a Data Point

If Input 1 is not HyperCube Measure, the Result cannot be a Data Point

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