Data Over Time Report/Dashboard

jr7922

Hi. I'm currently developing a dashboard to analyze metrics derived from support ticket submissions. I've been asked to provide insights into peak ticket hours, and I need assistance in generating the corresponding report/chart. Is it possible to use a "created" column from one sheet to generate a chart highlighting the peak hours for incoming support tickets? Or do I need to setup a sheet summary first?

Paul Newcome

You will need a helper column that strips the hour out of the submission date/time stamp.

=RIGHT("00" + (VALUE(MID([Date & Time Ticket Was Submitted]@row, 10, FIND(":", [Date & Time Ticket Was Submitted]@row) - 10)) + IF(AND(FIND"PM", [Date & Time Ticket Was Submitted]@row) > 0, MID([Date & Time Ticket Was Submitted]@row, 10, FIND(":", [Date & Time Ticket Was Submitted]@row) - 10) <> "12"), 12, 0)), 2)

This should give you a two digit hour for the time in 24 hour format which you can then group a report by, include a summary field in the report to count how many for each hour and then chart from the report.

Paul Newcome

You will need a helper column that strips the hour out of the submission date/time stamp.

=RIGHT("00" + (VALUE(MID([Date & Time Ticket Was Submitted]@row, 10, FIND(":", [Date & Time Ticket Was Submitted]@row) - 10)) + IF(AND(FIND"PM", [Date & Time Ticket Was Submitted]@row) > 0, MID([Date & Time Ticket Was Submitted]@row, 10, FIND(":", [Date & Time Ticket Was Submitted]@row) - 10) <> "12"), 12, 0)), 2)

This should give you a two digit hour for the time in 24 hour format which you can then group a report by, include a summary field in the report to count how many for each hour and then chart from the report.