View Single Post
  #1 (permalink)  
Old August 12th, 2008, 02:51 PM
Ed_Conde Ed_Conde is offline
Registered User
 
Join Date: Aug 2008
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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