The MongoDB Aggregation node executes an aggregation pipeline on a MongoDB database and returns the result as JSON cells in a table. Example aggregation pipeline:
[
{ $match: { status: "A" } },
{ $group: { _id: "$cust_id", total: { $sum: "$amount" } } }
]
For more details see the MongoDB documentation: