In this custom task grouping, you can display tasks grouped by a range of their percent complete values. The breakdowns show percent complete value of 10 percent point increments: 1-10%, 11-20%, etc.
The following grouping organizes projects by the percent complete value into one of these groupings:
- 0%
- 1-10%
- 11-20%
- 21-30%
- 31-40%
- 41-50%
- 51-60%
- 61-70%
- 71-80%
- 81-90%
- 91-99%
- 100%
To apply this grouping:
- Navigate to a list of tasks.
- From the Grouping drop-down menu, select New Grouping.
- Click Switch to Text Mode.
- Remove the text in the Group your Report area.
- Replace the text with the following code:
group.0.linkedname=direct
group.0.name=Percent Breakdown
group.0.notime=false
group.0.valueexpression=IF({percentComplete}=0,"0 %",IF({percentComplete}<=11,"1-10 %",IF({percentComplete}<=21,"11-20 %",IF({percentComplete}<=31,"21-30 %",IF({percentComplete}<41,"31-40 %",IF({percentComplete}<51,"41-50 %",IF({percentComplete}<61,"51-60 %",IF({percentComplete}<71,"61-70 %",IF({percentComplete}<81,"71-80 %",IF({percentComplete}<91,"81-90 %",IF({percentComplete}<100,"91-99 %","100 %")))))))))))
textmode=true - Click Save Grouping.
Thank you for taking the time to provide feedback. We appreciate and value your contribution to our site. Feedback provided here is regularly reviewed by our Product Documentation team. Please ensure your comments are specific to improving this help article. Any questions or requests outside this help article content should be directed to our Community User Forum or by submitting a ticket to customer support.
I've used the function - and it works. But only in the list view. Unfortunately it then messes up the chart in Reporting. Which is really where you want to be able to group by 'percent complete'. Instead of having lost of bars - you want to be able to cluster them.
Any advice?