Need to Create a New Field in Report

[Vasuki]

Need a new Field in ServiceNow Report as below

MTTR = Incident End - Incident Start date

[ersureshbe]

Hi,

If you require new field you should create in 'Incident' table. After field creation you should call the field in Report.

After field creation - you should write the Business rule to calculate the difference of end date - state date and check the field filled with correct output.

var startDate = createdateField name; // add your field name.

var endDate = EnddateField name; // add your field name

var diffSeconds = gs.dateDiff(startDate.getDisplayValue(), endDate.getDisplayValue(), true);
var days = parseInt(diffSeconds)*60*24;

gs.log('Days:'+days);

Please mark as correct answer if it helped.

Regards,

Suresh

[Vasuki]

HI Suresh,

Thank you for the reply. 

Yes, I can create a Field in incident table. but that is not preferable from our side.

because, For one report we don't prefer to create a field. do we have any other options ?

[ersureshbe · Accepted solution]

Hi, This is the table you can get the result in the report.

/metric_instance_list.do?sysparm_nostack=true.

Please mark as correct answer if it helped.

Regards,

Suresh.

[Ankur Bawiskar]

Hi,

Can you use Metrics for this reporting

Reporting on Incident Metric table

MTTR (Mean Time to Resolution) Reporting

how to extract MTTD and MTTR in Servicenow

Regards
Ankur