```
{"$sort": {"end_time": -1}},
{
"$group": {
"_id": {
"design_name": "$design_name",
"directory": "$directory",
"step_name": "$step_name",
},
"tool": {"$first": "$tool"},
"end_time":{"$first": "$end_time"},
"xxx": {"$first": "$metrics"},
},
{
"$group": {
"_id": {
"design_name": "$_id.design_name",
"directory": "$_id.directory"
},
"tool": {"$first": "$tool"},
"end_time": {"$first": "$end_time"},
"pv_metrics": {
"$push": {
"step_name": "$_id.step_name",
"design_name": "$_id.design_name",
"directory": "$_id.directory",
"tool": "$tool",
"end_time": "$end_time",
"metrics": "$xxx",
}
}
},
},
{"$sort": {"end_time": -1}},
{
"$group": {
"_id": "$_id.design_name",
"designs_by_dir": {"$push": "$pv_metrics"}
},
},
```
