MongoDB Aggregation: Counting distinct fields from array

Question

Need to count distinct tags on all registers in a mongodb query, using JS.

Register structure:

  {
  "_id": {
    "$oid": "62e593aed8fd9808777225e8"
  },
  "title": "“The world as we have created it is a process of our thinking. It cannot be changed without changing our thinking.”",
  "author": {
    "name": "Albert Einstein",
    "url": "https://quotes.toscrape.com/author/Albert-Einstein"
  },
  "tag": [
    "change",
    "deep-thoughts",
    "thinking",
    "world"
  ]
  }

biorubenfs · Accepted Answer · 2022-07-30 22:05:34Z

1

This could be useful. In addition to get the different values for the field, it returns the number of appearances:

db.collection.aggregate([
  {
    "$unwind": "$tag"
  },
  {
    "$group": {
      "_id": "$tag",
      "total": {
        "$sum": 1
      }
    }
  },
  
])

You can try here: https://mongoplayground.net/p/yXLYkJKO3Wf

answered Jul 30, 2022 at 22:05

biorubenfs

8451 gold badge9 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB Aggregation: Counting distinct fields from array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related