[{id:"A",date:"1 jan 18",value:"1"},{id:"A",date:"2 jan 18",value:"0"},{id:"A",date:"3 jan 18",value:"0"},{id:"B",date:"14 jan 18",value:"4"},{id:"B",date:"15 jan 18",value:"5"},{id:"B",date:"16 jan 18",value:"0"},]

db.collection.aggregate([{$addFields:{date:{$dateFromString:{dateString:"$date"}}}},{$sort:{date:1}},{$group:{_id:"$id",data:{$push:{value:"$value",date:"$date"}}}},{$project:{data:{$arrayElemAt:[{$filter:{input:"$data",cond:{$eq:["$$this.value","0"]}}},0]}}},{$replaceRoot:{newRoot:{$mergeObjects:[{id:"$_id"},"$data"]}}}])