Revenue and order count by status
“Total revenue and number of orders for each status, highest revenue first”
db.orders.aggregate([
{
$group: { _id: "$status", orders: { $sum: 1 }, revenue: { $sum: "$total" } }
},
{ $sort: { revenue: -1 } }
])- $group with _id: "$status" makes one output document per status.
- { $sum: 1 } counts documents; { $sum: "$total" } adds up the order totals.
| _id | orders | revenue |
|---|---|---|
| shipped | 1 | 37998 |
| pending | 1 | 32496 |
| delivered | 2 | 22096 |
| cancelled | 1 | 1299 |