[{"cust_id":"ABC","date":"2020-05-01","new_purchase":2},{"cust_id":"ABC","date":"2020-05-02","new_purchase":16},{"cust_id":"ABC","date":"2020-05-03","new_purchase":14},{"cust_id":"ABC","date":"2020-05-04","new_purchase":0},{"cust_id":"ABC","date":"2020-05-05","new_purchase":5},{"cust_id":"DEF","date":"2020-05-11","new_purchase":3},{"cust_id":"DEF","date":"2020-05-12","new_purchase":0},{"cust_id":"DEF","date":"2020-05-13","new_purchase":0},{"cust_id":"DEF","date":"2020-05-14","new_purchase":0},{"cust_id":"DEF","date":"2020-05-15","new_purchase":1},{"cust_id":"GHI","date":"2020-07-28","new_purchase":0},{"cust_id":"GHI","date":"2020-07-29","new_purchase":3},{"cust_id":"GHI","date":"2020-07-30","new_purchase":17},{"cust_id":"GHI","date":"2020-07-31","new_purchase":0},{"cust_id":"GHI","date":"2020-08-01","new_purchase":1},{"cust_id":"JKL","date":"2020-06-04","new_purchase":7},{"cust_id":"JKL","date":"2020-06-05","new_purchase":0},{"cust_id":"JKL","date":"2020-06-06","new_purchase":0},{"cust_id":"JKL","date":"2020-06-07","new_purchase":0},{"cust_id":"JKL","date":"2020-06-08","new_purchase":0},{"cust_id":"JKL","date":"2020-06-09","new_purchase":2}]

db.collection.aggregate([{"$group":{"_id":{"cust_id":"$cust_id","year":{"$arrayElemAt":[{"$split":["$date","-"]},0]},"month":{"$arrayElemAt":[{"$split":["$date","-"]},1]}},"daysAndBuys":{"$push":{"day":{"$convert":{"input":{"$arrayElemAt":[{"$split":["$date","-"]},2]},"to":"int"}},"buys":"$new_purchase"}}}},{"$addFields":{"sets":{"$map":{"input":"$daysAndBuys","as":"d","in":{"$cond":[{"$and":[{"$in":[{"$add":["$$d.day",1]},"$daysAndBuys.day"]},{"$in":[{"$subtract":["$$d.day",1]},"$daysAndBuys.day"]}]},["$$d.day",{"$add":["$$d.day",1]},{"$subtract":["$$d.day",1]}],""]}}}}},{"$addFields":{"sets":{"$filter":{"input":"$sets","as":"s","cond":{"$ne":["$$s",""]}}}}},{"$unwind":"$sets"},{"$addFields":{"daysAndBuys":{"$filter":{"input":"$daysAndBuys","as":"data","cond":{"$in":["$$data.day","$sets"]}}}}},{"$project":{"daysAndBuys":1,"total":{"$sum":"$daysAndBuys.buys"}}},{"$match":{"total":{"$gte":8}}}])