Create a report for incidents created and grouping by time of day

Brandon Akers
Tera Contributor

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. 

BrandonAkers_0-1736537516824.png

 

1 ACCEPTED SOLUTION

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:

JoshPetrick_0-1736545118878.png

 

Then you can end up with a report looking like this:

JoshPetrick_1-1736545165669.png

 

View solution in original post

8 REPLIES 8

Thank you, Josh.

This article was very helpful. I was able to create the three datasets needed for my report. Now I just have to figure out the group by feature that I need to organize my data.

Hi @Josh Petrick 
I tried the way you suggested, but its show no data to display, but there are data's.
Can you please help me.
I have attached the screenshot.

Your screenshot shows conditions "Created trend on or after 6 pm hour" and "Created trend on or before 4 pm hour".  Those can't both be true so that's why there's no data.  If you're trying to get tickets created between those 2 hours, you should swap them around so it's "Created trend on or after 4 pm hour" and "Created trend on or before 6 pm hour". 

Hi @Josh Petrick 
Thank for the help ,i have created the report but when a user with IST time zone preferred is refereeing the report its show different data for them.
How can i configure it so that its showing the same data and correct.
Have the attached the screenshot for the reference.

Thank for the hep in advance.