I got a request here and I’m not sure how to calculate. We got a project with all kinds of issues, when they transit to status of “Pending Build”, it means they are “resolved”; after that they will transit to status “Closed”. They can go through “SQA Confirm” to “Closed” as well. Only “Pending Build” and “Closed” are considered “Resolved”.
There is also a “Original Time Estimate” (hours) and “Engineer” (users) associated with each case.
We now need to calculate, on monthly basis, for each “Engineer”, how many issues were “resolved”, and how many “original time estimate” were associated with those resolved issues.
I got some idea from other post and updated my calculation below, but still some results are not correct.
We use “engineer” in each issue to specify who resolved the issue, and allocate “original estimate hourse” on each issue. Now we need calculate, per each month, how many original estimate hours are resolved by each engineer.
Using the calculation below, some results are still not correct. Please kindly advise? Thanks!