db={"songs":[{"_id":{"$oid":"60debdaae7593406b682e45d"},"slug":"albins-test-artister-branches-11","title":"Branches","artistName":"My test artisters","songAdministrators":[],"agreements":{"songComposition":{"$oid":"612c8d394459ebd2483a0920"}}}],"agreements":[{"_id":{"$oid":"612c8d394459ebd2483a0920"},"agreementVersion":[{"version":1,"allHaveSigned":false,"_id":{"$oid":"612c8d394459ebd2483a0921"},"approvalStatus":[{"_id":{"$oid":"612c8d394459ebd2483a0922"},"publisherSignsFor":{"$oid":"60801bef03a9cd5f4a097e76"},"signingPerson":{"$oid":"60d06fc53a7fc65be3787df8"},"isSignedByPublisher":true},{"_id":{"$oid":"612c8d394459ebd2483a0923"},"publisherSignsFor":null,"signingPerson":{"$oid":"60d06fc53a7fc65be3787df8"},"isSignedByPublisher":false},{"_id":{"$oid":"612c8d394459ebd2483a0921"},"publisherSignsFor":{"$oid":"60801bef03a9cd5f4a097e76"},"signingPerson":{"$oid":"60d06fc53a7fc65be3787df9"},"isSignedByPublisher":true}],"isLatestVersion":true,"createdAt":{"$date":"2021-08-30T07:48:09.979Z"}}],"addedAt":{"$date":"2021-08-30T07:48:09.979Z"},"__v":0}]}

db.songs.aggregate([{"$lookup":{"from":"agreements","localField":"agreements.songComposition","foreignField":"_id","as":"agreements"}},{"$unwind":"$agreements"},{"$unwind":"$agreements.agreementVersion"},{"$addFields":{"agreements.agreementVersion.approvalStatus":{"$filter":{"input":"$agreements.agreementVersion.approvalStatus","as":"item","cond":{"$eq":["$$item.signingPerson",ObjectId("60d06fc53a7fc65be3787df8")]}}}}},{"$facet":{"songs":[{"$group":{"_id":"$_id","title":{"$first":"$title"},"artistName":{"$first":"$artistName"},"agreements":{"$push":"$agreements"},"sum":{"$sum":{"$size":"$agreements.agreementVersion.approvalStatus"}}}},],"countAgreements":[{"$group":{"_id":null,"count":{"$sum":{"$size":"$agreements.agreementVersion.approvalStatus"}}}}]}},{"$project":{"songs":1,"sumAgreements":{"$arrayElemAt":["$countAgreements.count",0]}}}])