Percent Complete Report Builder Report for All Child Tasks for Each Milestone Work Item
![]() I am trying to build a "percent complete" report that reports that metric for all of the children Tasks for each Milestone within a given Plan. Here are my trace relationships for the Report Builder report:
I would like to evaluate the status of each Task (per Milestone) and publish a bar chart of what percent complete all the tasks are.
I've been successful in using a Custom Expression to create a column that has this percentage value in it, but it will only display in Table mode, not Graph mode.
My Custom Expression is as follows:
(SUM(if($Task:Status$="Completed", 1, 0)) / (SUM(if($Task:Status$="Completed", 1, 0) + (SUM(if($Task:Status$!="Completed", 1, 0)))) * 100
This expression's numerator counts each Task which is complete as 1 and then adds them up.
The expression's denominator counts each Task which is not complete as 1 and adds them up before counting each Task which is complete as 1 and adds them to the previous sum, forming the full universe of Tasks for this Milestone.
In Graph mode, every bar is stuck at 1.
However in Table mode, the correct values are displayed.
Any guidance is appreciated!
Note: Using Report Builder version 6.0.6.1
|
Accepted answer
![]() After working with IBM support, we determined that the solution to this problem was to rebuild the report from scratch, after which it works as intended! Ralph Schoon selected this answer as the correct answer
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.