How do I calculate the average of Duration (Resolved)?

[Prathamesh Chav]

Hi Team,

var ObjArray = [];

var gr = new GlideRecord("incident");

gr.addEncodedQuery("active=true^sys_idSTARTSWITH29549d12838312109d62b0d6feaad367^ORsys_idSTARTSWITH395fb456830312109d62b0d6feaad35e");

gr.query();

while (gr.next()) {

    var start = gr.sys_created_on;

    gs.info("This is created date:=" + start.getDisplayValue())

    var end = gr.resolved_at;

    gs.info("This is end date:=" + end.getDisplayValue())

   var diff = gs.dateDiff(start.getDisplayValue(), end.getDisplayValue());

   gs.info("Diff is:=" + diff)

   gs.info(diff);

   ObjArray.push(diff);

}

gs.info(ms)

gs.info(ObjArray);

var sum = 0;

  for (var i = 0; i < diff.length; i++) {

        sum += diff[i];

    }

    gs.info(sum / diff.length);

I am trying to find out the average time required for start to resolved?

but its not working can anyone help?

[Ankur Bawiskar]

@Prathamesh Chav 

this required for what purpose?

Is this for reporting?

[Prathamesh Chav]

yes

[AndersBGS]

Hi @Prathamesh Chav ,

Can you try to give some more background on the use case and the business requirement? What is it that the outcome should be from a business perspective.