locked
Excel Pivot Table Time of Day and Day of Week RRS feed

  • Question

  • I'm currently researching the visualisation of tweets by time of day and day of the week. As of now, I'm able to assign the day of the week to a specific date (tweet), so they are now grouped into weekdays. In the example attached there are a 1.000 (out of 90.000) tweets, where you can see the date/weekday connection and sum of tweets.

    However, I also want to group the tweets per hour of the day. So I do not want to average them over 24 hours, but count the tweets per hour. Can you please take a look at my sample data: all ideas are welcome!

    File office excel 2010
    dl.dropbox.com/u/5442552/TEST%20%28office%202010%29.xlsx
    • Edited by JFJC Monday, February 11, 2013 12:24 AM link
    Monday, February 11, 2013 12:21 AM

Answers