Database
[{"_id":{"$oid":"633a982186c443b693dc240c"},"date":"2022-09-27","file":"file_1","package":1,"packagecode":"xy/1","pshIdList":[],"userList":[{"userName":"user_1","crDate":"2022.09.28","boolId":1}]},{"_id":{"$oid":"633a982186c443b693dc240d"},"date":"2022-09-27","file":"file_2","package":2,"packagecode":"xy/2","pshIdList":[],"userList":[]}]
Query
db.collection.aggregate([{$set:{"username":{$filter:{input:"$userList",as:"user",cond:{"$eq":["$$user.boolId",1]}}}}},{$set:{"username":{$arrayElemAt:["$username",0]}}},{$set:{"username":{$ifNull:["$username.userName","na"]}}},{$group:{_id:{"date":{$concat:["date: ","$date",]},"file":{$concat:["file: ","$file"]},},"items":{$push:{"items":{$concat:["$packagecode"," - ","$username"]}}}}},{$group:{_id:"$_id.date","items":{$push:{"file":"$_id.file","items":"$items"}}}},{"$set":{"items":{"$map":{"input":"$items","as":"element","in":{items:"$$element.items",file:{"$concat":["$$element.file"," - ",{"$toString":{"$size":"$$element.items"}}]}}}},_id:{"$concat":["$_id"," - ",{"$toString":{"$sum":{"$map":{"input":"$items","as":"element","in":{"$size":"$$element.items"}}}}}]}}}])