<< Click to Display Table of Contents >> Aggregation |
Functions |
Syntax |
Instructions |
Examples |
---|---|---|---|
addToSet |
{ $addToSet: <expression> } |
Returns an array of all unique values that results from applying an expression to each document in a group of documents that share the same group by key. Order of the elements in the output array is unspecified. |
For example: { $addToSet: "$col" }; |
avg |
{ $avg: <expression> } |
Returns the average value of the numeric values. |
For example: { $avg: "$col" } |
first |
{ $first: <expression> } |
Returns the value that results from applying an expression to the first document in a group of documents that share the same group by key. Only meaningful when documents are in a defined order. |
For example: { $first: "$col" }; |
last |
{ $last: <expression> } |
Returns the value that results from applying an expression to the last document in a group of documents that share the same group by a field. Only meaningful when documents are in a defined order. |
For example: { $last: "$col" }; |
max |
{ $max: <expression> } |
Returns the maximum value. $max compares both value and type, using the specified BSON comparison order for values of different types. |
For example: { $max: [ 5, 8 ] } |
mergeObjects |
{ $mergeObjects: <document> } |
Returns a group of multiple documents.Note: The object here is a specific structure in mongo. |
For example: { $mergeObjects: "$object" } |
min |
{ $min: <expression> } |
Returns the minimum value. $min compares both value and type, using the specified BSON comparison order for values of different types. |
For example: { $min: [ 5, 8 ] } |
push |
{ $push: <expression> } |
Returns an array of all values that result from applying an expression to each document in a group of documents that share the same group by key. |
For example: { $push: { t1: "test1", t2: "test2" } } |
stdDevPop |
{ $stdDevPop: <expression> } |
Returns the population standard deviation of the input values. |
For example: { $stdDevPop: "$col" } |
stdDevSamp |
{ $stdDevSamp: <expression> } |
Calculates the sample standard deviation of the input values. Use if the values encompass a sample of a population of data from which to generalize about the population. $stdDevSamp ignores non-numeric values. |
For example: { $stdDevSamp: "$col" } |
sum |
{ $sum: <expression> } |
Calculates and returns the sum of numeric values. $sum ignores non-numeric values. |
For example: { $sum: "$col" } |