Database
[{_id:ObjectId("62990f96345ef9001d9f2dfe"),deletedAt:null,expiredAt:ISODate("2022-06-05T19:29:26.746Z"),dataBarang:[{vendor:ObjectId("6215dd91139c99003fe4c7cd"),currency:ObjectId("61f750b56ea409001e521043"),modelId:14,usdConvertion:1,price:15,leadTime:null,quantity:2}],cartItems:[ObjectId("62990f77345ef9001d9f2dfd")],reqNo:"f0124ae0-1072-4f18-ab90-a7d2d784e634",reqDate:ISODate("2022-06-03T00:00:00.000Z"),updatedAt:ISODate("2022-06-02T19:29:30.140Z"),createdAt:ISODate("2022-06-02T19:29:26.747Z"),__v:0,pickUpDate:ISODate("2022-06-03T00:00:00.000Z"),transactionDate:ISODate("2022-06-03T00:00:00.000Z")},{_id:ObjectId("62990fe9345ef9001d9f2e03"),deletedAt:null,expiredAt:ISODate("2022-06-05T19:30:49.081Z"),dataBarang:[{vendor:ObjectId("6215dd91139c99003fe4de15"),currency:ObjectId("61f750b56ea409001e521043"),modelId:14,usdConvertion:1,price:64.82,leadTime:14,quantity:1}],cartItems:[ObjectId("62990fcc345ef9001d9f2e02")],reqNo:"c2b378ad-87fd-4db4-96b8-6812cb1f2229",reqDate:ISODate("2022-06-03T00:00:00.000Z"),updatedAt:ISODate("2022-06-02T19:30:51.269Z"),createdAt:ISODate("2022-06-02T19:30:49.082Z"),__v:0,pickUpDate:ISODate("2022-06-03T00:00:00.000Z"),transactionDate:ISODate("2022-06-03T00:00:00.000Z")}]
Query
db.collection.aggregate([{$match:{transactionDate:{$gte:ISODate("2021-01-01"),$lte:ISODate("2023-01-20")}}},{$group:{_id:{$dateTrunc:{date:"$transactionDate",unit:"day"}},totalPrice:{$sum:{$sum:"$dataBarang.price"}}}}])