Gathering Historic Data for Defined Metrics

[Nic Nagtzaam]

Hi All,

I am trying to gather Historic data for two metrics I've just defined.

As an example I am looking to measure the mean time to resolve requested items based on the state field being set to closed:

var s = current.state;
if (s == 3)
  createMetric();

function createMetric() {
  var mi = new MetricInstance(definition, current);
  if (mi.metricExists()) 
    return; 

  var gr = mi.getNewRecord();
  gr.start = current.sys_created_on;
  gr.end = current.sys_updated_on;
  gr.duration = gs.dateDiff(gr.start.getDisplayValue(), gr.end.getDisplayValue());
  gr.calculation_complete = true;
  gr.insert();
}

Is there any possible way for me to capture the historic data for this metric so I can have meaningful data in the report ASAP?

Regards,

Nic

[Dr Atul G- LNG]

I think PA is best option to get this results. @Nic Nagtzaam