2 Replies Latest reply on Sep 4, 2013 4:14 PM by Chris Parker

    How do I group by day of the week from a series?

    Chris Parker

      I have data that contains a value for each 15 minute period of a day. For example:

       

      2013-09-01 00:00:00, 15

      2013-09-01 00:15:00, 14

      2013-09-01 00:30:00, 20

      ...

      2013-09-03 15:45:00, 19

      2013-09-03 16:00:00, 21

       

      I've been able to group by individual day and SUM it to show totals. I'd now like to take those values and group them by weekday so that I can see trends. I want to be able to answer a question like, do Mondays have more or less activity than Tuesdays?