[{"_id":"60ab3312623b0108338a9601","items":[{"type":"Tshirt","price":300,"quantity":2},{"type":"Top","price":100,"quantity":3}],"orderId":"ORD189","from":"abc","to":"xyz","createdAt":ISODate("2021-05-24T05:01:06.960Z"),"__v":0,"tracking":null}]

db.collection.aggregate([{"$group":{"_id":{"date":{"$dayOfMonth":"$createdAt"},"month":{"$month":"$createdAt"},"year":{"$year":"$createdAt"}},"count":{$sum:1},"totalPrice":{$sum:{$sum:{$map:{input:"$items",in:{$multiply:["$$this.price","$$this.quantity"]}}}}}}}])