I am trying to create a report to show incidents created during different hours of the day. I was originally looking at buckets from PA, but we do not have access to that in our instance. The groupings should be:
0-7 = Before Business Hours
7-9 = Before Core Hours
9-17 = During Core Hours
17-19 = After Core Hours
19-24 = After Business Hours
Or like the graph below.
You could create a field that stores the time of day on the incident/task table, but that would take some dev work. It would make the reporting easier, but probably not worth it.
You can also create a report like this by using multiple datasets (one for each time range), and use the Trend function in the conditions.
For example you could have a condition like this in one of the datasets:
Then you can end up with a report looking like this:
I have attempted to create custom report ranges and though it is giving me the values on a the report, it is not adhering to the parameters I set for the ranges
This is the drilldown for "before business hours" Notice the time range is nowhere near 6:59:59
You could create a field that stores the time of day on the incident/task table, but that would take some dev work. It would make the reporting easier, but probably not worth it.
You can also create a report like this by using multiple datasets (one for each time range), and use the Trend function in the conditions.
For example you could have a condition like this in one of the datasets:
Then you can end up with a report looking like this:
