I am working with a non-profit that manages teachers in schools. I am building an AppSheet app to track attendance. The database has all the students across all the schools and grades and the app allows the teacher to input attendance for all the students in a given grade in a given school at a time. I now want to build a metrics view that allows the teacher to look at average attendance for a given period and also flag individual students with less than some threshold attendance in that period. I am able to write an expression (SELECT(Attendance Log[StudentName],
AND([School] = [Select School], [Class] = [Select Class], [Present], [Date] >= [Start Date], [Date] <= [End Date]))) to get all the days all the students in a class were present during a given period, but I am now unsure how to get the attendance percentage for each individual student since I cannot seem to incorporate loop logic into the expression. Am I approaching this the right way? Any help would be appreciated!
LinkedIn
Twitter
