[{"failed":2,"passed":4,"asset_class":"A","run_date":new Date("2024-08-28")},{"failed":1,"passed":3,"asset_class":"A","run_date":new Date("2024-08-29")},{"failed":5,"passed":1,"asset_class":"A","run_date":new Date("2024-08-29")},{"failed":2,"passed":4,"asset_class":"B","run_date":new Date("2024-08-22")},{"failed":5,"passed":8,"asset_class":"B","run_date":new Date("2024-08-22")},{"failed":5,"passed":1,"asset_class":"B","run_date":new Date("2024-08-26")}]

db.collection.aggregate([{$group:{_id:{asset_class:"$asset_class",run_date:"$run_date"},totalFailed:{$sum:"$failed"},totalPassed:{$sum:"$passed"}}},{$sort:{"_id.asset_class":1,"_id.run_date":-1}},{$group:{_id:"$_id.asset_class",latestRunDate:{$first:"$_id.run_date"},totalFailed:{$first:"$totalFailed"},totalPassed:{$first:"$totalPassed"}}},{$project:{_id:0,asset_class:"$_id",run_date:"$latestRunDate",failed:"$totalFailed",passed:"$totalPassed"}}])