Have you taken a look at the Dates section on this page already? You might find some tips there.
I copied the sample data table into Tableau, and it recognized the dates/times automatically.
It may not be perfect, but are you after something like the attached?
I have used your example data, aggregated time by weekday and hour... split by unit.
Hope it gives you a starting point...
157133.twbx 11.8 KB
Thanks for reaching out, I appreciate it.
I'm really focused on that Disp. Date/Time column.
What I'm trying to trend over a few years is when we receive the bulk of our calls, e.g. Monday between 10-11am.
Since the data is in one column I'm having a hard time trying to bucket everything.
I think what I'll try doing in excel is splitting the date/time so
Column A = Date
Column B = Time
Then create a new column C that is the Day of the Week, and try to trend it that way. If you have a better approach, I'd love to hear it.
I agree with your approach, sounds reasonable to me.
Have you opened/ checked my workbook? I have started you off on this path...
Disp. Weekday: datename('weekday',[Disp. Date/Time])
by selecting only the weekday we can bucket a 1 year of data (for example) into just those 7 days, all 52 Monday's will appear as a single line.
Disp. Hour: datepart('hour',[Disp. Date/Time])
as above, but now splitting the hour from the date, use as a column
in the above/ attached I have also split by Unit although I'm not sure if that is required.
I can see that Thursday at 5pm is your busiest (assuming I should sum time) (for unit 3393)
and Thursday at 4pm for unit 3394
does that make sense? am i understanding what you're trying to do?