Hi there everyone - I’m wondering if I’ve missed something in the docs. I have a json field, which contains multiple tags which can be present for more than one user.
User 1 - [‘Tag1’, ‘Tag2’, ‘Tag3’]
User 2 - [‘Tag3’]
User 3 - [‘Tag1’, ‘Tag3’]
As a specific example, I’d like to count the occurrences like so, splitting the JSON fields into their individual parts, getting the complete, unique list and counting the occurrences.
A GET request which would return something like this:
I have no problem doing this with a normal text field with one value per row, but can’t see a way with a JSON field.
Is this possible? Or perhaps, is there a workaround that you’ve seen for this problem?
Thanks so much!