[

    {
      $match: {
        "creatorDeptId": {$exists: true},
        "claimCreate"    : {$exists: true},
        "customClaimNumber"    : {$exists: true},
        "currStatus.statusCode"    : {$exists: true},
        "daysToDeadline"  : {$exists: true},
        "service.name"    : {$exists: true},
        "service.srguServicePassportId"   : {$exists: true},
        "service.srguDepartmentName"    : {$exists: true},
        "oktmo": { $regex: "^46" } ,
"creatorDeptId": "mfc-odincovo"
      }
    },

    {
      $project: {
        "claimCreate"    : "$claimCreate",
        "statusDate"     : "$currStatus.statusDate",
        "statusCode"     : "$currStatus.statusCode",
        "consultation"   : "$consultation",
        "creatorDeptId"  : "$creatorDeptId",
        "daysToDeadline" : "$daysToDeadline",

        "provLevel": { $ifNull: [ "$provLevel"  , "" ] },
        "urmName":   { $ifNull: [ "$urmName"    , "" ] },
        "urmNumber": { $ifNull: [ "$urmNumber"  , "" ] },

        "in_claimCreate": { $and: [
          { $lte: [ "$claimCreate", { $date: "2016-06-05T00:00:00Z" } ] },
          { $gte: [ "$claimCreate", { $date: "2016-06-01T00:00:00Z" } ] }
         ] },

        "in_statusDate":  { $and: [
          { $lte: [ "$currStatus.statusDate", { $date: "2016-06-05T00:00:00Z" } ] },
          { $gte: [ "$currStatus.statusDate", { $date: "2016-06-01T00:00:00Z" } ] } ] },

        "in_deadline": {$and: [
          { $eq: [ "$consultation"  , false ] },
          { $lt: [ "$daysToDeadline", 0 ] },
          { $gt: [ "$daysToDeadline", -231 ] },
          { $eq: [ { $ifNull: [ "$resultStatus"  , "<null>" ] }, "<null>" ] },
          { $ne: [ { $ifNull: [ "$currStatus"    , "<null>" ] }, "<null>" ] },
          { $not: [ { $or: [
            { $eq: ["$currStatus.statusCode", "24"] },
            { $eq: ["$currStatus.statusCode", "3" ] },
            { $eq: ["$currStatus.statusCode", "4" ] },
            { $eq: ["$currStatus.statusCode", "41"] },
            { $eq: ["$currStatus.statusCode", "40"] },
            { $eq: ["$currStatus.statusCode", "42"] },
            { $eq: ["$currStatus.statusCode", "10"] },
            { $eq: ["$currStatus.statusCode", "19"] },
            { $eq: ["$currStatus.statusCode", "15"] },
            { $eq: ["$currStatus.statusCode", "20"] },
            { $eq: ["$currStatus.statusCode", "52"] },
         { $eq: ["$currStatus.statusCode", "62"] },
         { $eq: ["$currStatus.statusCode", "58"] },
         { $eq: ["$currStatus.statusCode", "59"] },
         { $eq: ["$currStatus.statusCode", "60"] },
         { $eq: ["$currStatus.statusCode", "61"] }
            ] } ] }
         ] },

        "in_work": {$and: [
          { $eq: [ "$consultation"  , false ] },
          { $eq: [ { $ifNull: [ "$resultStatus"             , "<null>" ] }, "<null>" ] },
          { $ne: [ { $ifNull: [ "$currStatus"               , "<null>" ] }, "<null>" ] },
          { $ne: [ { $ifNull: [ "$service.srguServiceId"    , "<null>" ] }, "<null>" ] },
          { $ne: [ { $ifNull: [ "$daysToDeadline"           , "<null>" ] }, "<null>" ] },
          { $not: [ { $or: [
            { $eq: ["$currStatus.statusCode", "24"] },
            { $eq: ["$currStatus.statusCode", "3" ] },
            { $eq: ["$currStatus.statusCode", "4" ] },
            { $eq: ["$currStatus.statusCode", "41"] },
            { $eq: ["$currStatus.statusCode", "40"] },
            { $eq: ["$currStatus.statusCode", "42"] },
            { $eq: ["$currStatus.statusCode", "10"] },
            { $eq: ["$currStatus.statusCode", "19"] },
            { $eq: ["$currStatus.statusCode", "15"] },
            { $eq: ["$currStatus.statusCode", "20"] },
            { $eq: ["$currStatus.statusCode", "52"] },
         { $eq: ["$currStatus.statusCode", "62"] },
         { $eq: ["$currStatus.statusCode", "58"] },
         { $eq: ["$currStatus.statusCode", "59"] },
         { $eq: ["$currStatus.statusCode", "60"] },
         { $eq: ["$currStatus.statusCode", "61"] }
            ] } ] }
         ] }

      }
    },

 {
      $group: {
        _id: { "creatorDeptId": "$creatorDeptId", "provLevel": "$provLevel", "urmName": "$urmName", "urmNumber": "$urmNumber" },
        a_consultation: { $sum: { $cond: [ { $and: [ { $eq: ["$in_claimCreate", true] }, { $eq: ["$consultation", true  ] } ] }, 1, 0 ] } },
        a_claim       : { $sum: { $cond: [ { $and: [ { $eq: ["$in_claimCreate", true] }, { $eq: ["$consultation", false ] } ] }, 1, 0 ] } },
        a_total       : { $sum: { $cond: [ { $and: [ { $eq: ["$in_claimCreate", true] }                                     ] }, 1, 0 ] } },

        a_completed   : { $sum: { $cond: [ { $and: [ { $eq: ["$in_statusDate", true] }, { $eq: ["$statusCode", "24"  ] } ] }, 1, 0 ] } },

        a_deadline       : { $sum: { $cond: [ { $and: [ { $eq: ["$in_deadline", true] } ] }, 1, 0 ] } },
        a_deadline7      : { $sum: { $cond: [ { $and: [ { $eq: ["$in_deadline", true] }, { $gt: ["$daysToDeadline", -7] } ] }, 1, 0 ] } },
        a_deadline7_14   : { $sum: { $cond: [ { $and: [ { $eq: ["$in_deadline", true] }, { $and:[ { $lte: ["$daysToDeadline", -7] }, { $gte: ["$daysToDeadline", -14] }] }  ] }, 1, 0 ] } },
        a_deadline14     : { $sum: { $cond: [ { $and: [ { $eq: ["$in_deadline", true] }, { $lt: ["$daysToDeadline", -14] } ] }, 1, 0 ] } },
        a_deadline_sum   : { $sum: { $cond: [ { $and: [ { $eq: ["$in_deadline", true] } ] }, "$daysToDeadline", 0 ] } },

        a_work           : { $sum: { $cond: [ { $and: [ { $eq: ["$in_work", true] } ] }, 1, 0 ] } }
      }
    }

  ]