[{"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":{"timeOfRequest":{"$gte":ISODate("2022-01-01T00:00:00Z"),"$lt":ISODate("2022-02-01T00:00:00Z")}}},{"$group":{"_id":"$requestingSupplier","TotalNumberAtPending":{"$sum":"$numberAtPending"},"TotalNumberAtInProgress":{"$sum":"$numberAtInProgress"},"TotalNumberAtCancelled":{"$sum":"$numberAtCancelled"},"TotalNumberAtShipped":{"$sum":"$numberAtShipped"},"Supplier":{"$first":"$requestingSupplier"}}}])