Database
[{"_id":ObjectId("bbbbbb1d9486c90479aaaaaa"),"record":{"debug":false,"type":"MX_GTI","products":["DAM"],"agents":[{"services":"mssql","hpsAvg":772,"hpsMax":42901},{"services":"mssql","hpsAvg":95,"hpsMax":21631},{"services":"oracle","hpsAvg":0,"hpsMax":0},{"services":"db2","hpsAvg":0,"hpsMax":0}]}}]
Query
db.collection.aggregate([{$match:{"record.type":"MX_GTI"}},{$unwind:"$record.agents"},{$group:{_id:"$record.agents.services","maxHPS":{$max:"$record.agents.hpsMax"},"avgHPS":{$avg:"$record.agents.hpsMax"}}}])