Hello there! I need help in counting string occurences inside an array and project them inside my data aggregation. The aggregation has a couple of aggregation steps but after the last $project stage the documents look like this: { id: 'Dynamic Ad Campaign', requestcount: 50, bookingcount: …

Hello @Georg_Bote , I have this aggregation which outputs the desired result. db.collection.aggregate([ { $unwind: "$flags" }, { $group: { _id: "$flags", count: { $sum: 1 }, regions: { $first: "$regions" }, doc: { $first: { id: "$id", requestcount: "$requestcount…

Project a counter of occurrences from document array

Working with Data

Georg_Bote (Georg Böte) January 11, 2022, 5:35pm 3

Thank you @Prasad_Saya ! This worked very well!

Getting the value of the most occurrences