Grouping: organize list results by a calculated value common to all objects in the grouping

Last update: Thu Feb 20 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Topics:
Reports and Dashboards

CREATED FOR:

User

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.

Grouping by calculated value

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.

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:

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.

recommendation-more-help