Progress percentage

Working with Data
2

Hello, @sunita_kodali !

I can help you to resolve your issue, but first - read the post about Formatting code and log snippets in posts. Remember: the better you explain your problem, provide examples and format your code in the posts - more people in the forum would want to help you :wink:

Ok, let’s create test collection with sample documents that would be close to your situation:

db.studentProgress.insertMany([
  {
    studentId: 'S1',
    courses: [
      {
        courseId: 'C1',
        courseName: 'Social',
        status: 'completed',
        score: 50
      },
      {
        courseId: 'C2',
        courseName: 'Math',
        status: 'completed',
        score: 100
      },
      {
        courseId: 'C3',
        courseName: 'Geography',
        status: 'completed',
        score: 80
      },
      {
        courseId: 'C4',
        courseName: 'Literature',
        status: 'enrolled',
        score: null
      },
      {
        courseId: 'C5',
        courseName: 'Spanish',
        status: 'enrolled',
        score: null
      },
    ],
  },
  {
    studentId: 'S2',
    courses: [
      {
        courseId: 'C1',
        courseName: 'Social',
        status: 'completed',
        score: 95
      },
      {
        courseId: 'C2',
        courseName: 'Math',
        status: 'enrolled',
        score: null
      },
    ],
  }
]);

We can easily calculate each student progress with the following aggregation pipeline:

db.studentProgress.aggregate([
  {
    $addFields: {
      totalCoursesEnrolled: {
        $size: '$courses'
      },
      totalCoursesCompleted: {
        $size: {
          $filter: {
            input: '$courses',
            cond: {
              $eq: ['$$this.status', 'completed']
            }
          }
        }
      }
    }
  },
  {
    $addFields: {
      percentageOfCompletedCourses: {
        $multiply: [
          { $divide: ['$totalCoursesCompleted', '$totalCoursesEnrolled'] },
          100
        ]

      }
    }
  },
  // clean results
  {
    $project: {
      _id: false,
      courses: false,
    }
  }
]);

Output:

[
  {
    studentId: 'S1',
    totalCoursesEnrolled: 5,
    totalCoursesCompleted: 3,
    percentageOfCompletedCourses: 60
  },
  {
    studentId: 'S2',
    totalCoursesEnrolled: 2,
    totalCoursesCompleted: 1,
    percentageOfCompletedCourses: 50
  }
]

Notice: you can not calculate fields and reuse them within the same stage. That is why I needed to use stage $addFields two times :wink:

1 Like