Hi all! I'm in the process of configuring dashboards, and for some multi-select fields in my database I'd like to be able to show a numerical value that says "for this record, they have x amount of fields selected". I've been trying to figure out how to achieve this with a count type function, and have been looking all through the count family, but cannot figure it out.
Here's a use case example to guide exploration: imagine you have a multi-select field called "dietary restrictions" and for every record you can assign any, all or none of: 'vegetarian' 'gluten free' 'pescatarian'. What I'm looking for is an additional field to the side of this giving a count of total amount of options actively selected for each record, so I can then create a chart that shows "30 people had zero dietary restrictions, 50 people had 1 dietary restriction, 20 people had 2 dietary restrictions, 12 people had 3 dietary restrictions". I do NOT need this count to have any content information about which dietary restrictions, I just want a count of how many options are selected - but all formulas I'm finding try to interact with the content in the multi-select field.
Any help would be appreciated!