[{"roomVisits":{"ROOM1":1}},{"roomVisits":{"ROOM1":8,"ROOM2":1}},{"roomVisits":{"ROOM1":1}},{"roomVisits":{"ROOM3":3}},{"roomVisits":{}},{"roomVisits":{"ROOM1":1}},{"roomVisits":{}},{"roomVisits":{"ROOM4":4}},{"roomVisits":{"ROOM5":1,"ROOM3":1}},{"roomVisits":{}},{"roomVisits":{"ROOM1":4}},{"roomVisits":{}},{"roomVisits":{"ROOM3":2}},{"roomVisits":{"ROOM6":3,"ROOM3":3}},{"roomVisits":{"ROOM3":6}},{"roomVisits":{}},{"roomVisits":{"ROOM1":2,"ROOM7":9}},{"roomVisits":{"ROOM7":24,"ROOM3":2}},{"roomVisits":{"ROOM3":4,"ROOM7":1}},{"roomVisits":{}},{"roomVisits":{"ROOM7":2}},{"roomVisits":{"ROOM3":3}},{"roomVisits":{"ROOM6":5,"ROOM3":20,"ROOM1":2}},{"roomVisits":{"ROOM3":3}},{"roomVisits":{}},{"roomVisits":{"ROOM8":3,"ROOM9":3,"ROOM10":2,"ROOM11":1,"ROOM12":1,"ROOM13":1}},{"roomVisits":{"ROOM10":3,"ROOM14":2,"ROOM9":2,"ROOM13":8,"ROOM11":2,"ROOM15":1,"ROOM8":3,"ROOM12":5,"ROOM16":1}},{"roomVisits":{"ROOM13":3,"ROOM12":2,"ROOM8":1,"ROOM10":1}},{"roomVisits":{"ROOM1":2}},{"roomVisits":{"ROOM3":4,"ROOM17":3}},{"roomVisits":{"ROOM17":13}}]

db.collection.aggregate([{"$match":{"roomVisits":{"$ne":{}}}},{"$addFields":{"roomVisitsArray":{"$objectToArray":"$roomVisits"}}},{"$unwind":"$roomVisitsArray"},{"$replaceRoot":{"newRoot":"$roomVisitsArray"}},{"$group":{"_id":"$k","visitCount":{"$sum":"$v"}}},{"$group":{"_id":"$visitCount","visitCount":{"$sum":1}}},{"$group":{"_id":null,"value":{"$push":{"k":{"$toString":"$_id"},"v":"$visitCount"}}}},{"$replaceRoot":{"newRoot":{"$arrayToObject":"$value"}}}])