It's all about the answers!

Ask a question

Percent Complete Report Builder Report for All Child Tasks for Each Milestone Work Item

Bob 3 (146540) | asked Mar 23, 7:20 p.m.
edited Mar 23, 7:21 p.m.

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

Accepted answer

permanent link
Bob 3 (146540) | answered Jun 07, 9:00 p.m.

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

Register or to post your answer.