8 Replies Latest reply on May 4, 2011 2:35 PM by jessica sufit

    Group by Hour and Minute

    jessica sufit

      I currently have a datetime data field as a dimension in my dataset and I would like to be able to create a grouping by time only.  I would like to have date on the x axis and time groupings on the y axis (5:30am - 6:00am, 6:00am - 7:00am, 7:00am - 8:00am, 8:00am - 8:30am) so I can do sums/averages by each time grouping for each date.  Any suggestions for how to accomplish this?