Reporting Question

[CV1]

Hi All,

Please guide how to create following reports using Incident table

Average Case Age (target < 2 days)

Oldest Open Case Age

SLA Restore trending Weekly

SLA Response trending Weekly

TIA

[Its_Azar]

Hi there @CV1 

To create the reports you need on the Incident table in ServiceNow, follow these steps: For the  Case Age (target < 2 days), create a report with a Single Score type, using Average aggregation on the Age field, and filter incidents with age < 2 days. For the Oldest Open Case ag, use a Single Score type with Maximum aggregation on the Age field, filtering for open incidents. For SLA Restore and Response Trending Weekly.

create Time Series reports on the SLA table, using Average or Count aggregation on the Business Elapsed Time field, grouped by week, and filter for the specific SLA type. Schedule these reports to run weekly.

Kindly accept the response if this helps thanks,

[CV1]

Hi @Its_Azar ,

How to create

• Average of all open cases < 2 days
• % of incidents under 2 days old
• oldest open case age in days.

[CV1]

What is "Age" field here? I am unable to find that field on inc table