Database
[{"creationDate":"2021/3/19","_id":"60549366ab4eb00aa1ed2fd9","avgPower":8241,"WaterConsumption":22},{"creationDate":"2021/3/19","_id":"605493f4ab4eb00aa1ed2fda","avgPower":8241,"WaterConsumption":22},{"creationDate":"2021/2/17","_id":"60549433ab4eb00aa1ed2fdb","avgPower":4300,"WaterConsumption":32,}]
Query
db.collection.aggregate({$match:{creationDate:"2021/3/19"}},{$group:{_id:"$creationDate",ids:{$push:"$_id"},total:{$sum:"$WaterConsumption"}}},{$project:{"creationDate":"$_id","_id":"$ids","WaterConsumption":"$total"}})