1

My document is:

  [
   { '_id': 1, number: 10, span: 5, rated:'Yes', sectionID: 3},
   { '_id': 2, number: 20, span: 6, rated:'Yes', sectionID: 3},
   { '_id': 3, number: 4, span: 5, rated:'No', sectionID: 5},
   { '_id': 4, number: 2, span: 0, rated:'Yes', sectionID: 6},
   { '_id': 22, number: 9, span: 6, rated:'No', sectionID: 3},
  ]

I want to sum number and span fields for sectionID 3 when they are rated

So the result will be like:

     number: 30, span: 11

I have looked at this great post but couldn't wrap my head around working with two fields at once.

Wede Asmera Tseada
  • 513
  • 2
  • 4
  • 14

0 Answers0