Hi All,
How to calculate cumulative time duration from the metric_instance table?
For example, when a change is rejected change will move back into the New phase and duplicate metric instances are generated for a unique change request record,
So they want a report to calculate the cumulative duration average time spent in the Asess / Authorize / Schedule phases like that
Screenshot for your reference
