[{"appointment_count":1,"item_id":2,"item_type":"user","company_id":5,"created_date":"2022-12-05","customer_count":1,"lead_count":1,"door_knocks":10},{"lead_count":2,"item_id":2,"item_type":"user","company_id":5,"created_date":"2022-12-06","video_viewed":2,"door_knocks":9},{"appointment_count":1,"item_id":3,"item_type":"user","company_id":5,"created_date":"2022-12-05","customer_count":1,"lead_count":1,"door_knocks":8},{"lead_count":2,"item_id":4,"item_type":"user","company_id":5,"created_date":"2022-12-06","video_viewed":2,"door_knocks":11}]

db.collection.aggregate([{$match:{company_id:5,created_date:{"$gte":"2022-12-04","$lte":"2022-12-06"}}},{$group:{_id:{item_id:"$item_id",company_id:"$company_id"},docs:{$push:"$$ROOT"},total_door_knocks:{$sum:"$door_knocks"}}},{$setWindowFields:{partitionBy:"$company_id",sortBy:{total_door_knocks:-1},output:{item_rank:{"$denseRank":{}},stat_sum:{"$sum":"$total_door_knocks"}}}},{$unwind:"$docs"},{$project:{_id:"$docs._id",appointment_count:"$docs.appointment_count",company_id:"$docs.company_id",created_date:"$docs.created_date",customer_count:"$docs.customer_count",door_knocks:"$docs.door_knocks",item_id:"$docs.item_id",item_type:"$docs.item_type",lead_count:"$docs.lead_count",item_rank:1,stat_sum:1,total_door_knocks:1}},{$facet:{metadata:[{"$count":"total"}],data:[{"$skip":0},{"$limit":100},{"$sort":{"item_rank":1}}]}}])