Aging Report

bhamm
Kilo Explorer

Has anyone created any Active Aging reports in SN (off the incidents table)? I would like to create an aging report and count tickets by windows (0-5 days, 6-10 days, etc.) Can something like this be created in a report? Any feedback is appreciated.

4 REPLIES 4

brozi
ServiceNow Employee
ServiceNow Employee

Here is a wiki link showing how to create a gauge. You should be able to createyour report filtering on opened. The reason i point to a gauge is that you can add it to the home page with a count of items you are filtering on.

You could also create a standard report filtering on the same items

Creating_a_New_Gauge_from_a_List_of_Records


rob_phillips
ServiceNow Employee
ServiceNow Employee

You can use a trend report to accomplish this.
Table: Incident
Type: Trend
Trend Field: Created per Week


The list calculations or the trend is not exactly what I am looking for. On a daily basis I want to know how old each ticket is, not just how many tickets there are per day. So today I want to know that there is 100 tickets between 0-5 days old and 200 tickets between 6-10 days old. Tomorrows numbers would change as each active ticket would be 1 day older.


Tom157
Kilo Contributor

I'm looking to do that same..anyone??