2 Replies Latest reply on Feb 17, 2015 2:56 PM by Yuriy Fal

    Showing total number of names using number of records as a category

    Omar Shaker

      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?!