How to calculate old data values in a newly created metric definition.

[Vibhuti Rajput]

Hi All,

I have created a new metric for table change request -> field value duration -> on field state.

The metric instances are getting created correctly from the time the metric definition was created .

But our instance has changes being created from last 6 months .

How can i get their state duration so that i can report the duration correctly .

Any idea ? maybe by some background script or schedule job ?

what script to use?

[Merzot]

Hi Vibhuti Rajput,

Did the script work for you? What did you end up using? Can you please give us an update on this.

Thanks,

Merzot