Click or drag to resize

ISetWindowFieldsPartitionExtensions Methods

The ISetWindowFieldsPartitionExtensions type exposes the following members.

Methods
  NameDescription
Public methodStatic memberAddToSetTInput, TValue
Returns a set.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDecimal, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDouble, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt32, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt64, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableSingle, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, SetWindowFieldsWindow)
Returns the average value of the numeric values. Average ignores non-numeric values.
Public methodStatic memberCountTInput
Returns the number of documents in the window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, FuncTInput, Decimal, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, FuncTInput, Double, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, FuncTInput, Int32, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, FuncTInput, Int64, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDecimal, FuncTInput, NullableDecimal, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDouble, FuncTInput, NullableDouble, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt32, FuncTInput, NullableInt32, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt64, FuncTInput, NullableInt64, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableSingle, FuncTInput, NullableSingle, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovariancePopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, FuncTInput, Single, SetWindowFieldsWindow)
Returns the population covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, FuncTInput, Decimal, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, FuncTInput, Double, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, FuncTInput, Int32, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, FuncTInput, Int64, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDecimal, FuncTInput, NullableDecimal, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDouble, FuncTInput, NullableDouble, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt32, FuncTInput, NullableInt32, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt64, FuncTInput, NullableInt64, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableSingle, FuncTInput, NullableSingle, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberCovarianceSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, FuncTInput, Single, SetWindowFieldsWindow)
Returns the sample covariance of two numeric expressions that are evaluated using documents in the partition window.
Public methodStatic memberDenseRankTInput
Returns the document position (known as the rank) relative to other documents in the $setWindowFields stage partition.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, WindowTimeUnit, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, WindowTimeUnit, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, WindowTimeUnit, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, WindowTimeUnit, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDerivativeTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, WindowTimeUnit, SetWindowFieldsWindow)
Returns the average rate of change within the specified window.
Public methodStatic memberDocumentNumberTInput
Returns the position of a document (known as the document number) in the $setWindowFields stage partition.
Public methodStatic memberExponentialMovingAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, ExponentialMovingAverageWeighting, SetWindowFieldsWindow)
Returns the exponential moving average value of the numeric values. Ignores non-numeric values.
Public methodStatic memberExponentialMovingAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, ExponentialMovingAverageWeighting, SetWindowFieldsWindow)
Returns the exponential moving average value of the numeric values. Ignores non-numeric values.
Public methodStatic memberExponentialMovingAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, ExponentialMovingAverageWeighting, SetWindowFieldsWindow)
Returns the exponential moving average value of the numeric values. Ignores non-numeric values.
Public methodStatic memberExponentialMovingAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, ExponentialMovingAverageWeighting, SetWindowFieldsWindow)
Returns the exponential moving average value of the numeric values. Ignores non-numeric values.
Public methodStatic memberExponentialMovingAverageTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, ExponentialMovingAverageWeighting, SetWindowFieldsWindow)
Returns the exponential moving average value of the numeric values. Ignores non-numeric values.
Public methodStatic memberFirstTInput, TValue
Returns the first value.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, WindowTimeUnit, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, WindowTimeUnit, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, WindowTimeUnit, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, WindowTimeUnit, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberIntegralTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, WindowTimeUnit, SetWindowFieldsWindow)
Returns the approximation of the area under a curve.
Public methodStatic memberLastTInput, TValue
Returns the last value.
Public methodStatic memberLocfTInput, TValue
Returns the last observation carried forward.
Public methodStatic memberMaxTInput, TValue
Returns the maximum value.
Public methodStatic memberMinTInput, TValue
Returns the minimum value.
Public methodStatic memberPushTInput, TValue
Returns a sequence of values.
Public methodStatic memberRankTInput
Returns the document position (known as the rank) relative to other documents in the $setWindowFields stage partition.
Public methodStatic memberShiftTInput, TValue(ISetWindowFieldsPartitionTInput, FuncTInput, TValue, Int32)
Returns the value from an expression applied to a document in a specified position relative to the current document.
Public methodStatic memberShiftTInput, TValue(ISetWindowFieldsPartitionTInput, FuncTInput, TValue, Int32, TValue)
Returns the value from an expression applied to a document in a specified position relative to the current document.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDecimal, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDouble, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt32, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt64, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableSingle, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationPopulationTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, SetWindowFieldsWindow)
Calculates the population standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDecimal, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDouble, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt32, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt64, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableSingle, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberStandardDeviationSampleTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, SetWindowFieldsWindow)
Calculates the sample standard deviation of the input values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Decimal, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Double, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int32, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Int64, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDecimal, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableDouble, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt32, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableInt64, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, NullableSingle, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Public methodStatic memberSumTInput(ISetWindowFieldsPartitionTInput, FuncTInput, Single, SetWindowFieldsWindow)
Returns the sum of numeric values. $sum ignores non-numeric values.
Top
See Also