Helping charting data by date

[James Gill]

I'm really drawing a blank here. I have fax logs that I need to analyze by the hour. So far I've set up two tables, Fax Report and Fax Item. Fax Report is the date that I want to create a report for and Fax Item represents each fax that has received.

So far I've managed to create two charts, one that summarizes the average numer of fax pages received for each day and one that summaries the total fax pages received per day. These were pretty easy to do.

I am running into serious trouble when it comes to creating a chart that summarizes the number of faxes received per hour for that particular day. I've pretty easily created the relationships that would allow me to see these values in calculated fields, but I'm really drawing a blank on how exactly I can use FIlemaker charts to visualize this. I should point out that I'm a relative newbie when it comes to Filemaker charts.

[comment]

I have fax logs that I need to analyze

What fields does a log have?