[{_id:ObjectId("67cfd69ba3e561d35ee57f51"),created_at:ISODate("2025-03-11T06:22:19.044Z"),conversation:[{id:"67cfd6c1a3e561d35ee57f53",feedback:{liked:false,disliked:true,copied:true,created_at:ISODate("2025-03-11T06:27:48.634Z")}},{id:"67cfd77fa3e561d35ee57f54",feedback:{liked:true,disliked:false,copied:false,created_at:ISODate("2025-03-11T06:28:25.099Z")}},{id:"67d009f1a3e561d35ee57f5a",feedback:null},{id:"67d009f8a3e561d35ee57f5b",feedback:null}]},{_id:ObjectId("67d00aeaa3e561d35ee57f5d"),created_at:ISODate("2025-03-11T10:05:30.848Z"),conversation:[{id:"67d00af7a3e561d35ee57f5f",feedback:null},{id:"67d00afaa3e561d35ee57f60",feedback:null}]}]

db.collection.aggregate([{"$match":{"conversation.feedback.copied":true}},{"$unwind":"$conversation"},{"$match":{"conversation.feedback":{"$ne":null}}},{"$group":{"_id":{"$dateToString":{"format":"%Y","date":"$conversation.feedback.created_at"}},"total_copied":{"$sum":{$cond:[{$eq:["$conversation.feedback.copied",true]},1,0]}},"total_liked":{"$sum":{"$cond":[{"$eq":["$conversation.feedback.liked",true]},1,0]}},"total_disliked":{"$sum":{"$cond":[{"$eq":["$conversation.feedback.disliked",true]},1,0]}}}},{"$replaceRoot":{"newRoot":{"$arrayToObject":[[{"k":"$_id","v":{"total_copied":"$total_copied","total_liked":"$total_liked","total_disliked":"$total_disliked"}}]]}}}])