Forum Discussion
Percentage of features completed
v-venuppu The solution is as follows
a) Create 2 Copies of the complete dataset as tables which has the list of all features and stores linked using ParentWorkItem ID
b) Rename the tables of dataset as Features and Stories
c) Create one to many relation from Features table by mapping Work Item ID field to Parent Work Item ID in Stories table
d) Create 2 measure - Completed Story Points and Total Story Points in the Features table
e) Completed Story Points - Use SumX to sum all stories that are in completed or done status
f) Total Story Points - Use SumX to sum the story points from all stories
f) Create a measure called % Completion using Completed and Total Story Points
Hi SureshA ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Regards,
Rama U.
Thanks for following up. I couldnt get the values right after creating the formulas given in the solution
However, i have managed to create the copy of the data set and establish 1 to many relationship from feature to story and able to derive the Features completion based on status and story points defined at stories and tasks
Hi SureshAnanth ,
Great to hear that it's working.Could you please share the solution? It would be really helpful for others in the community who might be facing similar issues and can address them quickly. Also, I would suggest accepting your approach as the solution so that it can benefit others as well.
Thank you.
v-venuppu The solution is as follows
a) Create 2 Copies of the complete dataset as tables which has the list of all features and stores linked using ParentWorkItem ID
b) Rename the tables of dataset as Features and Stories
c) Create one to many relation from Features table by mapping Work Item ID field to Parent Work Item ID in Stories table
d) Create 2 measure - Completed Story Points and Total Story Points in the Features table
e) Completed Story Points - Use SumX to sum all stories that are in completed or done status
f) Total Story Points - Use SumX to sum the story points from all stories
f) Create a measure called % Completion using Completed and Total Story Points