Grouping: organize list results by a calculated value common to all objects in the grouping
You might want to view your tasks grouped by Percent Complete in ranges of 0-25, 26-50, 51-75, 75-99, and 100. You can create a grouping using text mode to do this.
Access requirements
You must have the following access to perform the steps in this article:
table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header | |
---|---|
ÃÛ¶¹ÊÓƵ Workfront plan | Any |
ÃÛ¶¹ÊÓƵ Workfront license* |
New:
Current:
|
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.
Organize list results by a calculated value common to all objects in the grouping
To apply this grouping to a list of tasks:
-
Go to a list of tasks.
-
From the Grouping drop-down menu, select New Grouping.
-
Click Switch to Text Mode.
-
In the available space, add the following code:
code language-none textmode=true group.0.valueexpression=IF({percentComplete}>=0&&{percentComplete}<=25,'0-25%',IF({percentComplete}>25&&{percentComplete}<=50,'26-50%',IF({percentComplete}>50&&{percentComplete}<=75,'51-75%',IF({percentComplete}>75&&{percentComplete}<=100,'76-100%','')))) group.0.linkedname=direct group.0.valueformat=doubleAsString group.0.namekey=percentComplete
-
Click Done, then Save Grouping.
-
(Optional) Update the grouping name, then click Save Grouping.