How to access overall document count during arithmetic aggregation expression

by

One way to do it is use $setWindowFields:

db.collection.aggregate([
  {
    $setWindowFields: {
      output: {
        totalCount: {$count: {}}
      }
    }
  },
  {
    $unwind: "$items"
  },
  {
    $group: {
      _id: "$items.defindex",
      count: {$sum: 1},
      totalCount: {$first: "$totalCount"}
    }
  },
  {
    $project: {
      count: 1,
      usage: {$divide: ["$count", "$totalCount"]
      }
    }
  },
  {$sort: {count: -1}}
])

As you can see here

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Get names of all keys in the collection
  4. How to filter array in subdocument with MongoDB [duplicate]
  5. Does MongoDB’s $in clause guarantee order
  6. $lookup on ObjectId’s in an array
  7. MongoDB: Combine data from multiple collections into one..how?
  8. Multiple join conditions using the $lookup operator
  9. Return only matched sub-document elements within a nested array
  10. Converting string to date in mongodb
  11. MongoDB nested lookup with 3 levels
  12. MongoDB Full and Partial Text Search
  13. Mongodb Join on _id field from String to ObjectId
  14. How to get back the Original document back after aggregation
  15. Mongo sort on a calculated condition
  16. MongoDB lookup when foreign field is an array of objects
  17. MongoDB: Calculate dwell time between every status value change
  18. MongoDB: how to parse date in 3.6 mongoDb version?
  19. Search on multiple collections in MongoDB
  20. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  21. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  22. convert iso date to timestamp in mongo query
  23. Remove Duplicates from MongoDB
  24. Using $slice operator to get last element of array
  25. Mongodb aggregation pipeline how to limit a group push
  26. $project in $lookup mongodb
  27. Return actual type of a field in MongoDB
  28. Mongodb, aggregate query with $lookup
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. Return the last “true” value for each group

Leave a Comment