Database

[{"collection":"collection","count":100,"content":{"Title":{"type":"faker","method":"HipsterWord","maxDistinctValue":5},"subData":{"type":"object","objectContent":{"status":{"type":"enum","values":["Checked In","Checked Out","Missing"],"randomOrder":true,"nullPercentage":20}}}}}]

Query

db.collection.aggregate([{"$group":{"_id":{"Title":"$Title","status":{"$ifNull":["$subData.status",""]}},"count":{"$count":{}}}},{"$sort":{"_id.Title":1,"_id.status":1}},{"$replaceWith":{"$mergeObjects":["$_id",{"count":"$count"}]}}])

Result