I would be very convenient to filter students' attendance by section in the downloaded attendance report. E.g. in my course I have a section called "lectures" and a section called "projects". In the attendance menu in Canvas we do list the students' attendance by section. But when I download the attendance report and open it in Excel, I cannot filter by section. Or at least, I haven't been able to figure this out. The pivot table function Excel hasn't provided the solution I'm looking for (although it is a handy tool to list and check the attendance by student).
Anyone who knows how to solve this? Thank you!