Grouping: project percent breakdown 2
- Topics:
- Reports and Dashboards
CREATED FOR:
- User
In this custom project grouping, you can display projects grouped by a range of their percent complete values. The breakdowns show percent complete value of 10 percent point increments: 0-10%, 11-20%, 21-30% 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%
Access requirements
You must have the following access to perform the steps in this article:
New:
-
Contributor to modify a filter
-
Standard to modify a report
Current:
-
Request to modify a filter
-
Plan to modify a report
Edit access to Reports, Dashboards, Calendars to modify a report
Edit access to Filters, Views, Groupings to modify a filter
*For information, see Access requirements in Workfront documentation.
Group by project percent breakdown
To apply this grouping:
-
Go to a list of projects.
-
From the Grouping drop-down menu, select New Grouping.
-
Click Switch to Text Mode.
-
Remove the text in the box, and paste the following code in the available space:
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 Done > Save Grouping.
-
(Optional) Update the name of the grouping, then click Save Grouping.