4 Replies Latest reply on Jul 16, 2013 6:13 AM by Jonathan Drummey

    How to display average across hours of the day across weekdays

    Catherine Williams

      I have data for when posts were made to a facebook page, with the date and time they were Posted on (Posted on) and I'd like to analyse an average for each hour in the day, for each weekday, e.g. what is the average number of posts on a Monday between midnight and 1am from data for this year.  I've attached the raw data, and my attempt but I can't get them to work.  I was hoping for a barchart and a crosstab, so I'd appreciate any help or advice.

       

      Many thanks.