[{"_id":"63356af2d77a56d764f362e4","noteName":"string","category":"IDEA","content":"string","isArchived":true,"createdAt":"2022-09-29T09:52:50.477Z","updatedAt":"2022-09-29T09:52:50.477Z","__v":0},{"_id":"63356afad77a56d764f362ea","noteName":"string","category":"IDEA","content":"string","isArchived":false,"createdAt":"2022-09-29T09:52:58.765Z","updatedAt":"2022-09-29T09:52:58.765Z","__v":0},{"_id":"63356afbd77a56d764f362ee","noteName":"string","category":"IDEA","content":"string","isArchived":false,"createdAt":"2022-09-29T09:52:59.180Z","updatedAt":"2022-09-29T09:52:59.180Z","__v":0},{"_id":"63356b04d77a56d764f362f4","noteName":"string","category":"TASK","content":"string","isArchived":false,"createdAt":"2022-09-29T09:53:08.261Z","updatedAt":"2022-09-29T09:53:08.261Z","__v":0},{"_id":"63356b09d77a56d764f362fc","noteName":"string","category":"TASK","content":"string","isArchived":true,"createdAt":"2022-09-29T09:53:13.980Z","updatedAt":"2022-09-29T09:53:13.980Z","__v":0},{"_id":"63356b0ad77a56d764f362fe","noteName":"string","category":"TASK","content":"string","isArchived":true,"createdAt":"2022-09-29T09:53:14.445Z","updatedAt":"2022-09-29T09:53:14.445Z","__v":0}]

db.collection.aggregate([{$group:{_id:"$category",archived:{$sum:{$cond:["$isArchived",1,0]}},unArchived:{$sum:{$cond:["$isArchived",0,1]}}}},{$sort:{_id:1}}])