Okay, so... I am trying to create a few charts. And I have a few fields: (1) Name, (2)Gender, (3)Start Date, (4)Classroom
First chart I hope to create basically shows per classroom as 1. Then divides into two sections of gender. Then give a rate of gender in each classroom. So if we have 4 female students out of 20 students, chart should show a small pie slice of 20%. Then the rest would, obviously be the other 80%. I believe I need to make a formula, but did not know what to put down there. So as we click through classroom lists on the left side, as it would default to, pie chart would change pertaining to the gender difference in that class.
Second chart I wish to create is basically a graph chart that shows a list of all classrooms, and rate of female students in each class. So I can easily tell overall of which classrooms have less female rate.