- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-10-2025 11:34 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-10-2025 01:39 PM
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2025 12:32 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2025 02:37 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2025 06:33 AM
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".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2025 12:12 PM
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.