[{"task_id":"as4d2rds5","url":"https:example1.com","organization":"Avengers","val":"null"},{"task_id":"rfre43fed","url":"https:example1.com","organization":"Avengers","val":"valid"},{"task_id":"uyje3dsxs","url":"https:example2.com","organization":"Metro","val":"valid"},{"task_id":"ghs563vt6","url":"https:example1.com","organization":"Avengers","val":"invalid"},{"task_id":"erf6egy64","url":"https:example2.com","organization":"Metro","val":"null"}]

db.collection.aggregate([{"$group":{"_id":"$organization","val":{"$push":"$val"},"url":{"$first":"$url"}}},{"$project":{"_id":0,"organization":[{"k":"$_id","v":{"url":"$url","invalid":{"$size":{"$filter":{"input":"$val","cond":{"$eq":["$$this","invalid"]}}}},"valid":{"$size":{"$filter":{"input":"$val","cond":{"$eq":["$$this","valid"]}}}},"null":{"$size":{"$filter":{"input":"$val","cond":{"$eq":["$$this","null"]}}}}}}]}},{"$replaceRoot":{"newRoot":{"$arrayToObject":"$organization"}}}])