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: