# Single Variable Statistics

Operations

#### 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Any

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Any

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Any

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Any

• Data Point
• Variable
• Stack

• 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

• Data Point
• Literal
• Variable
• Stack

• Decimal
• Double
• Int16
• Int32
• Int64

• Data Point
• Variable
• Stack

• Decimal