Line chart with times and dates

[peterderrington]

Hi, 

My brains not working this morning!

I need to create a line chart that shows the attendance of a department over days and time.

The data currently looks like this:

I had wanted to have the date as a dimension across the bottom but couldn't then work out how to show the numbers in the department on the times during that day. I assume i'll need two dimensions but wasn't quite sure how to do it.

Thanks,

Peter

[peterderrington]

Wanted to be able to produce something similar to this (but obviously prettier):

[peterderrington]

Does anybody have any suggestions for this?

The best I could do was create a datestamp column in the original data by combing the date and time and then plotting that as the dimension however it looks very messy. (I've done it a as a bar graph in this instance but bar or line is irrelevant)