I am looking after a modern multi-disciplinary teaching lab where 8 different courses can be taught simultaneously. Current venue management system in place is not suitable for this lab, particularly with the bookings. I am exploring ways to illustrate the total student number by setting up a hourly student number trend curve per day in Filemaker based dashboard so that keep the student number under maximum number. Anyone with experience in setting up such trend curves? I have attached a powerpoint which describes the current data format table (slide 3) and how to convert to a table with hourly based calculation of total number of students across different course per hour, which will then serve the data to generate the trend curve. I appreciate any help. Thanks

Soma

X-Lab student number trends.pptx

Edited May 27, 201510 yr by soma55

I zapped up a little sample file. Feel free to take it apart. FMP13 format.

Don Wieland
DW Data Concepts

student_curve.zip

Thank you so much Don,

This is excellent, I am still figuring out your method since I am scientist than a programmer. I hope you don't mind incorporating to your solution and acknowledge you for this.

Soma Vignarajan

Charles Perkins Centre, University of Sydney

Hi Soma,

Sure thing. No problem there.

Good luck!

Don Wieland
DW Data Concepts