[{"name":"Scenario number one","category":"general","creationDateTime":"2020-06-15T00:18:35.608+00:00","status":"Passed"},{"name":"Scenario number one","category":"general","creationDateTime":"2020-06-15T00:11:35.608+00:00","status":"Failed"},{"name":"Scenario number one","category":"general","creationDateTime":"2020-06-15T00:08:35.608+00:00","status":"Passed"},{"name":"Scenario number two","category":"happy-path","creationDateTime":"2020-06-15T00:17:35.608+00:00","status":"Failed"},{"name":"Scenario number one","category":"general","creationDateTime":"2020-06-13T00:12:35.608+00:00","status":"Passed"},{"name":"Scenario number two","category":"happy-path","creationDateTime":"2020-06-12T00:11:35.608+00:00","status":"Failed"},{"name":"Scenario number two","category":"happy-path","creationDateTime":"2020-06-12T00:10:35.608+00:00","status":"Passed"}]

db.collection.aggregate([{$sort:{"creationDateTime":-1}},{"$addFields":{"date":{"$substr":["$creationDateTime",0,10]}}},{"$group":{"_id":{name:"$name",cat:"$category",cdt:"$date"},"category":{$first:"$category"},status:{$first:"$status"},name:{$first:"$name"},date:{$first:"$date"}}},{$project:{_id:0}}])