I have two tables:
‘people’ (including single select field for ‘dietary requirements’)
I can assign multiple people to each event. I then use a rollup field in ‘events’ linking to ‘people’ and the ‘dietary requirements’ field with this simple formula:
ARRAYJOIN((values), ", ")
It returns something like: None, Pescatarian, Vegetarian, None, None, None, None, None
What I would really like to see is:
1 x Pescatarian
1 x Vegetarian
6 x None (or No dietary requirements)
There are more than three options at the moment (e.g. ‘nut allergy’ and others, and as I add more people there will be additional dietary requirements to add to the single select field, no doubt.
What is the way to achieve this ‘count of same items’ please?