Database
[{"_id":ObjectId("5eef9ddb09fb776392b7e00c"),"date":ISODate("2020-06-09T15:56:05.777Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5eef9ddb09fb776392b7e00d"),"date":ISODate("2020-06-16T13:33:41.387Z"),"amount":20,"plaza":"Shimabala"},{"_id":ObjectId("5eef9ddb09fb776392b7e00e"),"date":ISODate("2020-06-15T14:52:51.420Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5eef9ddb09fb776392b7e00f"),"date":ISODate("2020-06-15T14:52:13.603Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5eef9ddb09fb776392b7e010"),"date":ISODate("2020-06-16T16:22:53.823Z"),"amount":20,"plaza":"Mumbwa"},{"_id":ObjectId("5eef9ddb09fb776392b7e011"),"date":ISODate("2020-06-20T16:32:50.950Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5eef9ddb09fb776392b7e012"),"date":ISODate("2020-06-16T13:34:18.070Z"),"amount":20,"plaza":"Shimabala"},{"_id":ObjectId("5eef9ddb09fb776392b7e013"),"date":ISODate("2020-06-16T16:24:09.577Z"),"amount":20,"plaza":"Mumbwa"},{"_id":ObjectId("5eef9ddb09fb776392b7e014"),"date":ISODate("2020-06-20T16:33:41.687Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5eef9ddb09fb776392b7e015"),"date":ISODate("2020-06-09T15:55:26.727Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5eef9ddb09fb776392b7e016"),"date":ISODate("2020-05-31T11:13:14.800Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5eef9ddb09fb776392b7e017"),"date":ISODate("2020-05-31T11:10:59.927Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5ef0448b81b0d201ce583251"),"date":ISODate("2020-06-02T09:57:00.090Z"),"amount":150,"plaza":"Katuba"},{"_id":ObjectId("5ef4ae62c746cb18df06ab24"),"date":ISODate("2020-06-25T14:01:16.547Z"),"amount":20,"plaza":"Katuba"},{"_id":ObjectId("5ef70897a91690446433c601"),"date":ISODate("2020-06-27T08:49:05.053Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5ef761ace88e61128cda7fc8"),"date":ISODate("2020-06-27T15:11:07.123Z"),"amount":20,"plaza":"Chongwe"},{"_id":ObjectId("5ef8470cb84410217d72da18"),"date":ISODate("2020-06-28T07:22:03.647Z"),"amount":20,"plaza":"Chongwe"}]
Query
db.collection.aggregate([{$addFields:{dateOnly:{"date":{"$dateToString":{"format":"%Y-%m-%d","date":"$date"}}}}},{$group:{_id:null,data:{$push:"$$ROOT"},allPlaza:{$addToSet:"$plaza"}}},{$unwind:"$data"},{"$replaceRoot":{"newRoot":{"$mergeObjects":["$data","$$ROOT"]}}},{$group:{_id:{date:"$dateOnly.date",plaza:"$plaza"},amount:{$sum:"$amount"},allPlaza:{"$first":"$allPlaza"}}},{$group:{_id:"$_id.date",plaza:{$push:{plaza:"$_id.plaza",amount:{$sum:"$amount"}}},allPlaza:{"$first":"$allPlaza"}}},{$project:{data:{$map:{input:"$plaza",in:{k:"$$this.plaza",v:"$$this.amount"}}},allPlaza:{$map:{input:"$allPlaza",in:{k:"$$this",v:0}}}}},{$project:{data:{"$concatArrays":["$allPlaza","$data"]}}},{$addFields:{sum:{$reduce:{input:"$data",initialValue:0,in:{$add:["$$this.v","$$value"]}}}}},{$project:{data:{"$arrayToObject":"$data"},sum:1}},{$addFields:{"data.total":"$sum"}}])