Accumulators
push(field) Pushes the value of the selected field from a group into an array.
pushU(field) Pushes only the unique value of the selected field from a group into an array.
pushUC(field) Pushes only the unique value of the selected field from a group into an array in a cumulative way.
average(field) Returns the average of the values of the selected field from a group.
The field argument must be numeric. Non-numeric values or missing values will be ignored.
averageC(field) Returns the average of the values of the selected field from a group in a cumulative way.
The field argument must be numeric. Non-numeric values or missing values will be ignored.
sum(field) Returns the sum of the values of the selected field from a group.
The field argument must be numeric. Non-numeric values will be ignored.
sumC(field) Returns the sum of the values of the selected field from a group in a cumulative way.
The field argument must be numeric. Non-numeric values will be ignored.
max(field) Returns the maximum value of the selected field from a group.
The field argument must be numeric. If it has null or has no value at all, it will be ignored.
min(field) Returns the minimum value of the selected field from a group.
The field argument must be numeric. If it has null or has no value at all, it will be ignored.
first(sort, order) Returns the first document from a group. The group can be either sorted or not.
sort: Allows you to specify which field to sort. No sorting will happen if left empty.
order: 1 means ascending; -1 means descending. The default value is 1.
Last modified 1yr ago
Copy link