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

Last update: February 20, 2025

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 planAny
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 permissionsManage 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:

  1. Go to a list of tasks.

  2. From the Grouping drop-down menu, select New Grouping.

  3. Click Switch to Text Mode.

  4. 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

  5. Click Done, then Save Grouping.

  6. (Optional) Update the grouping name, then click Save Grouping.

Previous pageGrouping: add a fourth grouping to a list
Next pageGrouping: display the result of aggregating multiple calculated values in a grouping

Workfront