[{"_id":{"$oid":"6688c2f6b79f2bfefb751d5f"},"date":"06/07/2024","serviceStatus":[{"home":"http://www.bbc.co.uk/ontologies/passport/home/Marathi","count":8},{"home":"http://www.bbc.co.uk/ontologies/passport/home/Indonesia","count":4}]},{"_id":{"$oid":"66860a80b79f2bfefb7513cc"},"date":"04/07/2024","serviceStatus":[{"home":"http://www.bbc.co.uk/ontologies/passport/home/Pashto","count":10},{"home":"http://www.bbc.co.uk/ontologies/passport/home/Zhongwen","count":4}]}]

db.collection.aggregate([{"$set":{"serviceStatus":{"$map":{"input":"$serviceStatus","as":"ss","in":{"$mergeObjects":["$$ss",{"homeShort":{"$substrCP":["$$ss.home",0,2]}}]}}}}},{"$merge":{"into":"collection"}}])