[{data:{agent:{"name":"Samus Aran","id":"ID123456"}},"time":ISODate("2023-04-24T00:00:00.000Z"),"type":"success"},{data:{agent:{"name":"Samus Aran","id":"ID123456"}},"time":ISODate("2023-04-24T00:00:00.000Z"),"type":"error"},{data:{agent:{"name":"John Doe","id":"ID654321"}},"time":ISODate("2023-04-24T00:00:00.000Z"),"type":"error"},{data:{agent:{"name":"Jean Moulin","id":"ID456123"}},"time":ISODate("2023-04-24T00:00:00.000Z"),"type":"success"}]

db.collection.aggregate([{$sort:{type:-1}},{$group:{"_id":{"name":"$data.agent.name","id":"$data.agent.id","time":{"$dateToString":{"format":"%m-%d-%Y","date":"$time"}},},"type":{"$addToSet":"$type"}}},{$set:{type:{$first:"$type"}}}])