Generating hourly trend curve

[soma55]

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, 2015 by soma55

[dwdata]

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

Don Wieland
DW Data Concepts

student_curve.zip

[soma55]

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

[dwdata]

Hi Soma,

Sure thing. No problem there.

Good luck!

Don Wieland
DW Data Concepts