Database

[{"createdAt":new Date("2022-02-10T00:00:00.000Z"),name:"stack",value:"3"},{"createdAt":new Date("2022-02-10T00:00:00.000Z"),name:"google",value:"30"},{"createdAt":new Date("2022-03-10T00:00:00.000Z"),name:"stack",value:"33"},{"createdAt":new Date("2022-04-10T00:00:00.000Z"),name:"google",value:"32"},{"createdAt":new Date("2022-03-10T00:00:00.000Z"),name:"google",value:"31"},{"createdAt":new Date("2022-02-10T00:00:00.000Z"),name:"stack",value:"13"},{"createdAt":new Date("2022-04-10T00:00:00.000Z"),name:"stack",value:"23"},{"createdAt":new Date("2022-02-10T00:00:00.000Z"),name:"google",value:"33"},{"createdAt":new Date("2022-04-10T00:00:00.000Z"),name:"google",value:"43"},{"createdAt":new Date("2022-03-10T00:00:00.000Z"),name:"stack",value:"32"},{"createdAt":new Date("2022-02-10T00:00:00.000Z"),name:"stack",value:"35"},{"createdAt":new Date("2022-04-10T00:00:00.000Z"),name:"google",value:"38"}]

Query

db.collection.aggregate([{$set:{date:{"$dateToString":{"date":"$createdAt","format":"%Y-%m-%d"}}}},{$group:{_id:{date:"$date",name:"$name"},"total":{$sum:{$toInt:"$value"}}}},{$project:{_id:0,date:"$_id.date",name:"$_id.name",total:"$total"}}])

Result