Metrics definitions on assigned_to field using script calculation

[somadileep840]

Hi All,
I am new to metrics and in learning stage , require some help with Script. Here i want to create metric definition on assigned_to field ,which can be done using TYPE:Field value duration .But here i want to achieve same results using
TYPE : script calculation . Some one pls share me the Draft code.

Thanks in Advance
Soma

[Bert_c1]

Look at the OOB Metric Definition named "Open" (MTRC0000007) in my instance.

// script can set answer to false to terminate processing of the metric
// mi - MonitorInstance
// answer
if (!current.active) {
  answer = false;
  mi.endDuration();
  closeDurations(mi.current);
}

function closeDurations(current) {
    var gr = new GlideRecord('metric_instance');
    gr.addQuery('id', current.sys_id);
    gr.addQuery('calculation_complete', false);
    gr.addQuery('definition.type', 'field_value_duration');
    gr.query();
    while (gr.next()) {
       var definition = new GlideRecord('metric_definition');
       definition.get(gr.definition);
       var mi = new MetricInstance(definition, current);
       mi.endDuration();
    }
}
  

[Dr Atul G- LNG]

Hi @somadileep840 

Did you checkOOTB metrics

[somadileep840]

Hi @Dr Atul G- LNG ,
I want to get this with Type: Script calculation

[Dr Atul G- LNG]

Hi @somadileep840 

If you can achieve this without scripting, is there any specific reason you’re looking to use scripts?