Group and count by month

by

You need to use the $month keyword in your group. Your new Date().getMonth() call will only happen once, and will try and create a month out of the string “$bookingdatetime”.

db.booking.aggregate([
    {$group: {
        _id: {$month: "$bookingdatetime"}, 
        numberofbookings: {$sum: 1} 
    }}
]);

More Related Contents:

  1. Exception: can’t convert from BSON type EOO to Date
  2. convert iso date to timestamp in mongo query
  3. Mongodb aggregation pipeline how to limit a group push
  4. Random record from MongoDB
  5. Find in Double Nested Array MongoDB
  6. MongoDB: upsert sub-document
  7. Find MongoDB records where array field is not empty
  8. How do I update Array Elements matching criteria in a MongoDB document?
  9. MongoDB – Update an object in nested Array
  10. Get a count of total documents with MongoDB when using limit
  11. To what level does MongoDB lock on writes? (or: what does it mean by “per connection”
  12. Mongo order by length of array
  13. Mongodb Explain for Aggregation framework
  14. Best practice to maintain a mgo session
  15. Failed to start mongod.service: Unit mongod.service not found
  16. Mongodb Aggregation Framework: Does $group use index?
  17. Using MongoDB $pull to delete documents within an Array
  18. How to solve mongoDB related issue efficiently? [closed]
  19. Geospatial $near within current document field value
  20. mongodb, replicates and error: { “$err” : “not master and slaveOk=false”, “code” : 13435 }
  21. querying a collection without passing schema in mongoose
  22. Find documents whose array field contains at least n elements of a given array
  23. How to configure MongoDB Java driver MongoOptions for production use?
  24. MongoDB: Find Subdocument in Array Matching Parameters
  25. Meteor: uploading file from client to Mongo collection vs file system vs GridFS
  26. MongoDB $lookup on nested document
  27. How are MongoDB’s ObjectIds generated?
  28. How to get all result if unwind field does not exist in mongodb
  29. Get a document in MongoDB without specifying collection
  30. How to get a specific embedded document inside a MongoDB collection? [duplicate]

Leave a Comment