Hi all, one of our metrics for changes is the average time it takes to close an incident after the planned end date. I know to calculate this correctly I will have to filter out any changes that were closed before the planned end date in the actual report.
What I am struggling with is how to code / script the existing duration field in the change table to capture the date difference. Obviously it can only be calculated once the change has been closed, so I don't believe a dictionary override will work.
Any suggestions would be greatly appreciated. I am still a newbie to coding so please provide as much detail as possible.
Regards, Neil
