Hi,
Goal
I want draw sprint burndown chart based on Remaining Estimations which are taken as a sum of such values from subtasks. I want to be aware on what's going on in sprint with development progress.
Introduction
We use agile board for sprint work. For now it's important to have ability build burndown chart based on Original Estimate instead of Story Points.
The main issue there is that Agile Board don't use Original/Remaining estimate values from subtasks of features were taken in sprint. The only one option - log time to main ticket (no subtasks). But that's completely wrong because of mess with QA and Developers logging.
Possible solution
Steps:
1. Add 3 fields (New Feature, Bug, Bug Story, Task)
- Development remaining
- QA remaining
- ALL remaining
2. Create some Job which will do following
- Monitors "active sprints" content under specific project
- Let's assume this should be happened every 1-5 minutes (depends on ? )
3. For each ticket from "active sprints" Job should do following
- Calculate all remaining estimates from all "development task" subtasks and put sum to "Development remaining" field
- Calculate all remaining estimates from all "QA task" subtasks and put sum to "QA remaining" field
- Calculate all remaining estimates from all subtasks and put sum to "ALL remaining" field
Then we will have additional fields which will be updated by aggregate value of remaining estimates. So it will be clear how sprint is going from development point of view.
Is there some tools can be used for updating new field?