I am looking to calculate average daily attendance percentages. Specifically, if 90% of students attended class on Monday, 80% attended on Tuesday, and 70% attended on Wednesday I should get 80%. While I've been able to find some posts on averages, none of the advice I've run across seems to cover quite what I'm looking to do.
Our records include individual student records, their attendance where T=attended and F=absent, the city they go to school in, and their class.
I can currently see the number of students who attended by day using the attendance field and the associated percent using the following calculated field: Count([Attended?]=true)/ total (count([Attended?]))
Is there any way to create a table that shows the average of these percentages? I would like to see these percentages at the classroom level and the city level.
