Hey guys!

I am creating this report for engagement in a coaching program and I am trying to report on the total number of engagement.

I have the last names of participants on the y-axis and the #number of records (which is also the number of sessions attended) on the x-axis.

Ultimately I want to create a chart that shows that the total number of participants who attended 1 session, 2 sessions and 3 sessions.

Sounds simple, but I just cant get that to happen with this workbook!

I imagine a pie chart with 3 colors for each sessions (number of records) and with total number of participants in size mark tool.

I am having a problem getting that done though...Help?!