Forum Discussion
How to filter by the hour?
So I have a 3 months worth of dataset comprises of 3 columns: Date, Time and Calls_Offered.
My objective is to analyze on which particular hour is the busiest (most Calls_Offered) so we can identify which hour we can add resources and which hour we'll get resources from.
Since i have to plot the hours and calls_offered first on a column chart, I Merged the date and time so now I have 2 columns left: DateTimeMerge, Calls_Offered. but when i try to visualize it on a stacked column chart, the minimum I can get is by the day.
Is there a better way to do this?
- Anonymous8 years ago
Hi zpaul_010,
I'd like to suggest you extract date part and hour from merged datetime column, then use hour as x axis, date as legend, offer as view fields to create chart.
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
Hi zpaul_010,
I'd like to suggest you extract date part and hour from merged datetime column, then use hour as x axis, date as legend, offer as view fields to create chart.
Regards,
Xiaoxin Sheng