[{"numberAtPending":3,"numberAtInProgress":5,"numberAtCancelled":1,"numberAtShipped":50,"timeOfRequest":ISODate("2022-01-10T12:52:15.813Z"),"requestingSupplier":"SUPPLIER_1",},{"numberAtPending":5,"numberAtInProgress":3,"numberAtCancelled":4,"numberAtShipped":35,"timeOfRequest":ISODate("2022-01-15T09:11:02.992Z"),"requestingSupplier":"SUPPLIER_1",},{"numberAtPending":12,"numberAtInProgress":3,"numberAtCancelled":1,"numberAtShipped":21,"timeOfRequest":ISODate("2022-01-10T14:21:55.221Z"),"requestingSupplier":"SUPPLIER_2",}]

db.collection.aggregate([{"$match":{"$expr":{"$and":[{"$eq":[{"$month":"$timeOfRequest"},1]},{"$eq":[{"$year":"$timeOfRequest"},2022]}]}}},{"$group":{"_id":"$requestingSupplier","TotalNumberAtPending":{"$sum":"$numberAtPending"},"TotalNumberAtInProgress":{"$sum":"$numberAtInProgress"},"TotalNumberAtCancelled":{"$sum":"$numberAtCancelled"},"TotalNumberAtShipped":{"$sum":"$numberAtShipped"},"Supplier":{"$first":"$requestingSupplier"}}}])