After changing the dataset from columnar to rows, I was able to plot a pie chart percent of total by participation type.
- Changed the dataset columns [participation type] to rows [per client id]
- Drag count to sheet
- Switch the mark type to pie from automatic
- Drag Participation type to color
- Add quick table calculation > Percent of Total
Pie chart mockup_v10.5.twbx 16.9 KB
This worked for me; thanks!