Team - I have a metric set up in our change table to record the time between the end date of the change and when it is closed. Creating the metric has improved our Change Manager's ability to manage compliance, however they have identified that time over a weekend should not be included - ie if a change finishes at 1PM on Friday and is closed at 1 PM on the following Monday it should capture 1 day (24 hours)
Is anybody able to assist - below is the current code working as initially requested:
Cheers
if (current.state == 3)
createMetric();
if (current.state == 4)
createMetric();
function createMetric() {
var mi = new MetricInstance(definition, current);
if (mi.metricExists())
return;
var gr = mi.getNewRecord();
gr.start = current.work_end;
gr.end = current.closed_at;
gr.duration = gs.dateDiff(gr.start, gr.end);
gr.calculation_complete = true;
gr.insert();
}
