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:

Adobe Workfront plan*
Any
Adobe Workfront license*

Request to modify a grouping

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 grouping

NOTE

If you still don’t have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report

For information on requesting additional access, see Request access to objects.

*To find out what plan, license type, or access you have, contact your Workfront administrator.

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:

    code language-none
    textmode=true<br>group.0.valueexpression=IF({percentComplete}>=0&&{percentComplete}<=25,'0-25%',IF({
    
    code language-none
    percentComplete
    
    code language-none
    }>25&&{percentComplete}<=50,'26-50%',IF({percentComplete}>50&&{percentComplete}<=75,'51-75%',IF({percentComplete}>75&&{percentComplete}<=100,'76-100%',''))))<br>group.0.linkedname=direct<br>group.0.valueformat=doubleAsString<br>group.0.namekey=percentComplete
    
  5. Click Done, then Save Grouping.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43