Need help creating a report with report ranges

km123
Kilo Contributor

Hi all,

I need some help here. I've created a report that looks at open incident tickets each hour and groups them by location (See below).

find_real_file.png

I would like the chart to look like this:

find_real_file.png

I feel like I'm so close, I just need help on finishing this up. What I need is to be able to change the x-axis so that it shows 5 minute increments for that hour (for example, 10:05, 10:10, 10:15, and so on) and lists the incident tickets opened in between those 5 minute increments for that hour. I believe I would use report ranges, but I could be wrong. I have never used report ranges before and there isn't much documentation on creating one from scratch.

Does anyone know how to accomplish this? Much appreciated!

5 REPLIES 5

I should update this properly. When you build a range, it will be reflected in the field you've chosen from the table. Once you build your report, you would choose that field in the Group By and all records which fall into those ranges will be separated accordingly. Thanks!