Database

[{"_id":ObjectId("62372c37ea4cbb005e97ec1c"),"CreatedTime":ISODate("2022-03-20T13:29:27.456Z"),"Name":"Name1","Surname":"Surname1","Company":"Company1","ContactInformation":null},{"_id":ObjectId("62372c37ea4cbb005e97ec1d"),"CreatedTime":ISODate("2022-03-20T13:29:27.456Z"),"Name":"Name2","Surname":"Surname2","Company":"Company2","ContactInformation":[{"InfoType":1,"Info":"+905554443322"},{"InfoType":3,"Info":"İstanbul"}]},{"_id":ObjectId("62372c37ea4cbb005e97ec1e"),"CreatedTime":ISODate("2022-03-20T13:29:27.456Z"),"Name":"Name3","Surname":"Surname3","Company":"Company3","ContactInformation":[{"InfoType":1,"Info":"+905554443301"},{"InfoType":1,"Info":"+905554443302"},{"InfoType":3,"Info":"Kastamonu"}]},{"_id":ObjectId("62372c37ea4cbb005e97ec1f"),"CreatedTime":ISODate("2022-03-20T13:29:27.456Z"),"Name":"Name4","Surname":"Surname4","Company":"Company4","ContactInformation":[{"InfoType":3,"Info":"Kastamonu"}]}]

Query

db.collection.aggregate([{$addFields:{country:{$arrayElemAt:[{$filter:{input:"$ContactInformation",as:"info",cond:{$eq:["$$info.InfoType",3]}}},0]},ContactInformation:{$ifNull:["$ContactInformation",[]]}}},{$group:{_id:"$country.Info",recordCount:{$sum:1},phoneNumCount:{$sum:{$size:{$filter:{input:"$ContactInformation",as:"info",cond:{$eq:["$$info.InfoType",1]}}}}}}}])

Result