Grouping: task percent breakdown 1
- 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 25 percent point increments: 0-25%, 25-50%, etc.
The following grouping organizes tasks by the percent complete value into 6 different groupings:
- 0%
- 1-25%
- 26-50%
- 51-75%
- 76-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 task percent breakdown
To apply this grouping:
-
Go to a list of tasks.
-
From the Grouping drop-down menu, select New Grouping.
-
Click Add grouping.
-
Click Switch to Text Mode.
-
Remove the text in the Group by 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}<=26,"0-25 %",IF({percentComplete}<=51,"26-50 %",IF({percentComplete}<=76,"51-75 %",IF({percentComplete}<100,"76-99 %","100 %"))))) group.0.valueformat=string -
Click Done > Save Grouping.
-
(Optional) Update the grouping name, then click Save Grouping.