[{"_id":"id_1","User":"user_1","TotalNumber":50,"SuccessNumber":50,"__v":0,"receiverNumbers":[{"phoneNumber":"01 23 45 67 89","resultSend":{"senderNumber":"00 00 00 00 00","messageText":"Hello World sent 1","dateTime":"2023-01-18","send":true}},{"phoneNumber":"01 23 45 67 89","resultSend":{"senderNumber":"00 00 00 00 00","messageText":"Hello World sent 2","dateTime":"2023-01-18","send":true}},{"phoneNumber":"01 23 45 67 89","resultSend":{"senderNumber":"00 00 00 00 00","messageText":"Hello World not sent 1","dateTime":"2023-01-18","send":false}},{"phoneNumber":"01 23 45 67 89","resultSend":{"senderNumber":"00 00 00 00 00","messageText":"Hello World sent 3","dateTime":"2023-01-18","send":true}},{"phoneNumber":"01 23 45 67 89","resultSend":{"senderNumber":"00 00 00 00 00","messageText":"Hello World not sent 2","dateTime":"2023-01-18","send":false}},]},]

db.collection.aggregate([{"$addFields":{"totalSent":{$sum:{"$map":{"input":"$receiverNumbers","as":"val","in":{$cond:["$$val.resultSend.send",1,0,]}}}}}}])