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.
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)