[{"_id":1,"email":"customer1@email.com","packageid":"movies","command":"activated","tid":"123","createdAt":ISODate("2021-06-08")},{"_id":2,"email":"customer2@email.com","packageid":"movies","command":"activated","tid":"124","createdAt":ISODate("2021-06-20")},{"_id":3,"email":"customer1@email.com","packageid":"movies","command":"deactivated","tid":"1234","createdAt":ISODate("2021-06-10")},{"_id":4,"email":"customer2@email.com","packageid":"movies","command":"deactivated","tid":"1244","createdAt":ISODate("2021-06-22")},{"_id":5,"email":"customer1@email.com","packageid":"movies","command":"activated","tid":"123","createdAt":ISODate("2021-06-11")},{"_id":6,"email":"customer2@email.com","packageid":"movies","command":"activated","tid":"1244","createdAt":ISODate("2021-06-23")},{"_id":7,"email":"customer1@email.com","packageid":"movies","command":"deactivated","tid":"1237","createdAt":ISODate("2021-06-15")},{"_id":8,"email":"customer2@email.com","packageid":"movies","command":"deactivated","tid":"1244","createdAt":ISODate("2021-06-25")},]

db.collection.aggregate([{"$setWindowFields":{"partitionBy":{email:"$email",packageid:"$packageid"},"sortBy":{"createdAt":1},"output":{"next":{$shift:{output:"$createdAt",by:1}}}}},{$match:{"command":"activated"}},{$project:{email:"$email",packageid:"$packageid","days":{"$dateDiff":{startDate:"$createdAt",endDate:{$ifNull:["$next","$$NOW"]},unit:"day"}}}}])