Hour by Hour Matrix Report
Here is what I want to do. I want to be able to create a report that on the column will display TicketCategory and on each row will display the amount of tickets grouped by Hour. My problem is that I can't find an easy way of grouping the data by hour when creating my matrix.
Here is a sample of the raw data in my dataset:
[u]
#DATETIME #TICKETCATEGORY #TICKETQTY </u>
08/12/2008 10:05 AM ADULT 1
08/12/2008 10:10 AM CHILD 1
08/12/2008 10:30 AM ADULT 1
08/12/2008 11:05 AM ADULT 1
This is how my report should look like
[u]
#TIME // #TICKETCATEGORY
#ADULT #CHILD</u>
9:00 AM 0 0
10:00 AM 2 1
11:00 AM 1 0
|