How to calculate the time between a defect was fixed minus it was reported
I am looking for finding the time between a defect was fixed minus it was reported. The data I am trying to collect is how fast the developer could fix a defect.
'The actual fix time' field essentially considers date closed minus creation date so it really cannot help with that I am trying to achieve.
ALM version I have is 12.53
Thank you Alden!
I guess the below query returns the no of days between the today and when it was reported.
What I am looking for is the duration between detected date and the date when the defect status was turned into 'Fixed' for the first time. We have defect fix turnaround times defined at the start of the project. This is an attempt to see if we are really able to stick to that.
You should have a condition when the defect status changes.. so in pseudo code..
If the Defect status changes to "Fixed" then
Calculate date difference between detected date and current date -- this is the date from detected to when it was fixed
And if you can to track the no. of days it was retested to closed, then you should track the Fixed Date too and use it in the calculation.