How to get top 10 customers with most turnover?
$group
byowner
, get sum ofgetCartTotalPrice
$sort
bytotalTurnover
descending order$limit
10 documents
let Top10Clients = await Order.aggregate([ { $group: { _id: "$owner", totalTurnover: { $sum: "$getCartTotalPrice" } } }, { $sort: { totalTurnover: -1 } }, { $limit: 10 }]);