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();
}
