Need help with calculating how much time defect sits in a particular status.  If defect is submitted as New 10/2, doesn’t get picked up for review until 10/10; then it moves to development on 10/20, then moves to coding on 11/2, then UAT on 11/15—basically need a way to track # of days defect is in each status that will be selected from a drop-down list. I’ve provided sample below.  Do I need to track additional data in order to calculate this?  Thanks

DefectDescriptionStatusCreated on Date1234Something is brokenNew9/3/20244321Something broke againImplementation Review3/21/20244322Something broke againIn Development3/22/2024

​Need help with calculating how much time defect sits in a particular status.  If defect is submitted as New 10/2, doesn’t get picked up for review until 10/10; then it moves to development on 10/20, then moves to coding on 11/2, then UAT on 11/15—basically need a way to track # of days defect is in each status that will be selected from a drop-down list. I’ve provided sample below.  Do I need to track additional data in order to calculate this?  Thanks DefectDescriptionStatusCreated on Date1234Something is brokenNew9/3/20244321Something broke againImplementation Review3/21/20244322Something broke againIn Development3/22/2024  Read More

​