Grouping: task percent breakdown 2

Last update: October 30, 2024

Topics:
Reports and Dashboards

CREATED FOR:

User

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%

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to perform the steps in this article:

Adobe Workfront plan	Any
Adobe Workfront license*	New: Contributor to modify a filter Standard to modify a report Current: Request to modify a filter Plan to modify a report
Access level configurations	Edit access to Reports, Dashboards, Calendars to modify a report Edit access to Filters, Views, Groupings to modify a filter
Object permissions	Manage permissions to a report

*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}<=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 grouping name, then click Save Grouping.