Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Metric definition script to calculate custom table state duration

Mabubi
Tera Contributor

HI,

 

Can any one help here to calculate the custom table state duration .

 

The condition should be state changes then metric instance  should created & then state changes to another state metric  instance should be closed ,calculate the state duration ,the new state metric instance should be create same the flow.

 

I have state values multiple states like 20 choice.

 

currently am doing this below script but it will work only one state to another state changes. I need to include all state values to be include in one metric definition script..can you let me know please

 

 

Script:

    if (current.u_status.getDisplayValue() == "Received" ) {
        createMd();
    } else if (current.u_status.getDisplayValue() == " Search") {
        closeMd();
    }

    //calls the script include "MetricInstance" and create a metric instance
    function createMd() {
        var md = new MetricInstance(definition, current);

        //  check if a metric instance exists already
        if (md.metricExists()) {
            return;
        }
        var gr = md.startDuration();
    }

    //calls the script include "MetricInstance" and close the metric instance
    function closeMd() {
        var md = new MetricInstance(definition, current);

        if (md.metricExists()) {
            md.endDuration();
        }
    }

 

 

1 REPLY 1

Uncle Rob
Kilo Patron

Have you looked at the OOB "Open" metric for Incidents?  It does something similar.

UncleRob_0-1732556643896.png