10 Replies Latest reply: Jul 26, 2012 8:22 PM by mvinasco RSS

    How do I pull out the Day of Week from a Date File (plus average counts)

      I have a data set and I want to pull a couple of different things out.

      First of all - I have the month already as a separate field (example:  1,2,3)

       

      I would like to pull out the 'day of week' from a date format loaded as:    mm/dd/yyyy

       

      I have data spread over a year.

       

      I also have 'hour' of incident as a separate field.

       

      I can create a chart that displays the number of incidents for each hour (and each month).

       

      What I want is:

       

      To be able to find out the 'average' number of incidents for each hour (through the dataset), and also by day of week and month

       

      So: in the end, I can have a chart(s) that will show average # of incidents (count) by hour /day/ month.

       

      Any help would be appreciated.