MongoDB: Total count of distinct values in array field

Question

I've got simple documents like

{
  ...,
  things: ["a", "b", "c"]
},
{
  ...,
  things: ["b", "d", "e"]
},
...

and I want a total count of distinct things, in this case: ["a","b","c","d","e"], the result should be 5.

How to do this using an aggregate query?

My current attempt is

[
  {
    "$group": {
      "_id": "things",
      "things": { "$push": "$things" }
    }
  },
  {
    "$addFields": {
      "allThings": {
        "$reduce": {
          "input": "$things",
          "initialValue": [],
          "in": {
            "$concatArrays": ["$$value", "$$this"]
          }
        }
      }
    }
  }
]

which yields all fields in a single array, but I have no idea how to count distinct values in there now.

Happy for any help!

halfer · Accepted Answer · 2020-05-16 18:33:38Z

2

This is literally the first MongoDB query I ever wrote. It works, but happy to hear about improvements:

db.collection.aggregate([
    {
        $group: {
            _id: null,
            things: { $push: "$things"}
        }
    },
    {
        $project: {
            _id: 0,
            things: {
                $reduce: {
                    input: "$things",
                    initialValue: [],
                    in: {
                        $setUnion: [ "$$this", "$$value"]
                    }
                }
            }
        }
    },
    {
      $project: {
         item: 1,
         numberOfUniqueThings: {  $size: "$things" }
      }
   }
])

edited May 16, 2020 at 18:33

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Apr 5, 2020 at 18:40

Johannes Jasper

9211 gold badge8 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: Total count of distinct values in array field

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