1 ACCEPTED SOLUTION
Hi @Danielle10,
Please find the below screenshot and script that will help achieve this for you (Tried and tested on the HR table on my PDI - Personal Dev Instance).
Please note @Danielle10 - This Metric will only be created when the HR Case is saved in the state of 'Awaiting Acceptance'. (And not before)
To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.
Thanks, Robbie
Screenshot (A new 'Metric Definition')
Script:
// variables available
// current: GlideRecord - target incident
// definition: GlideRecord - (this row)
var s = current.state;
if (s == 20)
createMetric();
function createMetric() {
var mi = new MetricInstance(definition, current);
if (mi.metricExists())
return;
var hrCaseAwaitAcc = mi.getNewRecord();
hrCaseAwaitAcc.start = current.sys_created_on;
hrCaseAwaitAcc.end = current.sys_updated_on;
hrCaseAwaitAcc.duration = gs.dateDiff(hrCaseAwaitAcc.start.getDisplayValue(), hrCaseAwaitAcc.end.getDisplayValue());
hrCaseAwaitAcc.calculation_complete = true;
hrCaseAwaitAcc.insert();
}
Hi @Danielle10
No need to add start / end time. once you save this metric and update the HR case then it capture automatically.
