How to get top 10 customers with most turnover? How to get top 10 customers with most turnover? mongoose mongoose

How to get top 10 customers with most turnover?


  • $group by owner, get sum of getCartTotalPrice
  • $sort by totalTurnover descending order
  • $limit 10 documents
let Top10Clients = await Order.aggregate([  {    $group: {      _id: "$owner",      totalTurnover: { $sum: "$getCartTotalPrice" }    }  },  { $sort: { totalTurnover: -1 } },  { $limit: 10 }]);

Playground