You’ll want to check out how to format code and data fragments, you can use the buttons above to do this as it makes things a LOT easier for people to take what you post and try it out.
I’m not 100% sure I understand what you want but I think it could be something like this if you want to get a list of distinct values in that field.
You could use objectToArray to convert it, unwind them and then finally group them all up.
Example:
I would be a touch wary though, this will not be that performant if you have moderate quantities of data, I’ve not tested it with large volumes though so if you take this approach you’ll need to check that out.
2 Likes
