I currently have a date column with data represented in the following format: 2017-10-23 08:56:21
For a full picture, this represents the time of day I received a phone call.
I would like to change this so that I can count the number of calls per day and per hour of operation on a chart. For example, for the past month, what is call frequency on ALL Monday's, Tuesday, etc.
Then, drill down through a specific day to determine when most of the calls come in as it pertains to time of day.
Any help would be appreciated.
Thank you,
Steve Gonser