[{"userName":"johnDoe","email":"johnDoe@gmail.com","uploads":[{"_id":"adh12451e0012ce9da0","fileName":"TestDoc.txt","fileType":"text/plain","created":ISODate("2021-01-06T15:26:14.166Z"),"attachmentStatus":[]},{"_id":"5ff5d6c066cacc0012ed655a","fileName":"testerABC.txt","fileType":"text/plain","created":ISODate("2021-01-06T15:26:56.027Z"),"attachmentStatus":[{"_id":"60884f733f88bd00129b9ad4","status":"Uploaded","date":ISODate("2021-04-22T02:23:00Z")},{"_id":"60884f733f88bd00129b9ad5","status":"Processing","date":ISODate("2021-04-26T04:54:00Z")}]},{"_id":ObjectId("6075c82a19fdcc0012f81907"),"fileName":"Test file.docx","fileType":"application/word","created":ISODate("2021-04-13T16:34:50.955Z"),"attachmentStatus":[{"_id":"72844f733f88bd11479b9ad7","status":"Uploaded","date":ISODate("2021-04-23T03:42:00Z")},{"_id":"724986d73f88bd00147c9wt8","status":"Completed","date":ISODate("2021-04-24T01:37:00Z")}]}]},{"userName":"janeDoe","email":"janeDoe@gmail.com","uploads":[{"_id":"ej9784652h0012ce9da0","fileName":"myResume.txt","fileType":"text/plain","created":ISODate("2021-02-13T12:36:14.166Z"),"attachmentStatus":[{"_id":"15dhdf6f88bd00147c9wt8","status":"Completed","date":ISODate("2021-04-24T01:37:00Z")}]}]}]

db.collection.aggregate([{"$match":{"uploads.attachmentStatus":{"$elemMatch":{"status":{"$exists":true}}}}},{$unwind:"$uploads"},{$unwind:"$uploads.attachmentStatus"},{$sort:{"uploads.attachmentStatus.date":-1}},{$group:{_id:"$uploads._id",status:{$first:"$uploads.attachmentStatus.status"}}},{$sortByCount:"$status"},{$project:{_id:0,status:"$_id",Count:"$count"}}])