Trying to set up attendance for students
Hello. I've been using File maker Pro for a few weeks and decided that I'd use it to help maintain the student records for a dojo. My idea was that I wanted to create a line chart that shows the date on the Y-axis (m/d/y) and the day on the X-axis (Monday, Thursday, Saturday). I got as far as creating a student record from the Starter Solution and creating a line chart to be placed next to the students picture, but I'm having difficulty figuring out the rest. My idea was that I wanted to track on what days the students came to class via there ID Number.
You'll want the date on the X axis, which can be formatted to show the day name, but the Y axis needs to show a count of the students attending that day, not the date.
How did you set up your database to record attendance for each day?