Edit

Window operators - operators

Window operators perform calculations across a set of documents in a specified window.

Other

Description
$covariancePop The $covariancePop operator returns the covariance of two numerical expressions
$covarianceSamp The $covarianceSamp operator returns the covariance of a sample of two numerical expressions
$denseRank The $denseRank operator assigns and returns a positional ranking for each document within a partition based on a specified sort order
$derivative The $derivative operator calculates the average rate of change of the value of a field within a specified window.
$documentNumber The $documentNumber operator assigns and returns a position for each document within a partition based on a specified sort order
$expMovingAvg The $expMovingAvg operator calculates the moving average of a field based on the specified number of documents to hold the highest weight
$integral The $integral operator calculates the area under a curve with the specified range of documents forming the adjacent documents for the calculation.
$linearFill The $linearFill operator interpolates missing values in a sequence of documents using linear interpolation.
$locf The $locf operator propagates the last observed non-null value forward within a partition in a windowed query.
$rank The $rank operator ranks documents within a partition based on a specified sort order.
$shift usage on DocumentDB A window operator that shifts values within a partition and returns the shifted value.