Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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??