I made an attempt, but it may not necessarily be better/proper/easier.
I mocked up some data and loaded it into Prep.
(My mock data may not be structured like yours, please adjust and repost
that datasource as needed).
In Prep, I converted each field into 1 or 0 flags.
I then aggregated these flags to give me the counts.
And this is the key part: I pivoted the aggregates so that I use the Pivot Field name in
future labelling calculations.
I made two outputs, not sure which you'll need:
1) just the aggregated counts
2) the aggregated counts joined back to the original datasource to bring back student level detail.
Please see attached in the Forum Thread the workbook v10.3, the flow, and the datasource:
Thank you - I am looking at the files you attached to help me! I'm not overly fluent in Tableau Prep (yet), so this is a good opportunity to work on those skills! I'm hoping I can apply this to my workbook/data as your solution may not be pretty/correct, it seems to do what I need it to do.
I will update if this worked!