score.js

db.getCollection('person_report').aggregate([
{
    $match: {
        _id: {$in: [ObjectId("5995d36e61e71c54a042d859")]},
        roles: {
            $elemMatch: {
                    roleId: {$in: [ObjectId("599586c861e71c54a042d84b")]},
                    "production.eventDate": {$gte: ISODate("2019-01-02T17:00:00.000Z")},
                    "production.eventDate": {$lte: ISODate("2017-01-02T17:00:00.000Z")},
                }
        }
    
    }
},


{
      $project: {
        _id: true,
        firstName: true,
        lastName: true,
        kind: true,
        roles: {
            $filter: {
               input: "$roles",
               as: "role",
               cond: {
                    $and: [
                            { $gte: [ "$$role.production.eventDate", ISODate("2017-06-21T16:00:00.000Z") ] },
                            { $lte: [ "$$role.production.eventDate", ISODate("2020-12-11T17:00:00.000Z") ] },
                            { $eq: [ "$$role.roleId", ObjectId("599586c861e71c54a042d84b") ] },
                        ]
                   }
            }
         }
      }
   },
   
   {
      $project: {
        _id: true,
        firstName: true,
        lastName: true,
        kind: true,
        roles: true,
        ratings: {
              $filter: {
               input: "$roles",
               as: "r",
               cond: {$gte: ["$$r.ratings.score", 0]}
            }
         },
        totalShows: {$size: "$roles"},
        
      }
   },
   {
      $project: {
        _id: true,
        firstName: true,
        lastName: true,
        kind: true,
        ratings: {$avg: "$ratings.ratings.score"},
        totalShows: {$size: "$roles"},
      }
   },
       
       

])