$match, $group, $sort
“Revenue per status, without cancelled orders”
db.orders.aggregate([
{ $match: { status: { $ne: "cancelled" } } },
{ $group: { _id: "$status", revenue: { $sum: "$total" } } },
{ $sort: { revenue: -1 } }
])- $match drops cancelled orders before any work is done.
- $group collapses the remaining orders into one row per status with summed totals.
| _id | revenue |
|---|---|
| shipped | 37998 |
| pending | 32496 |
| delivered | 22096 |