View and grouping: display project Actual Duration aggregated by the average in a Grouping

You can add the following column in a project report to show the Actual Duration aggregated as an average in a grouping.

project_with_aggregate_actual_duration_in_grouping_view.png

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 view

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 view

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.

Display project Actual Duration aggregated by the average in a Grouping

To add this column to a project view:

  1. (Recommended) For best results and to see the aggregated average value of the Actual Duration, you must have a Grouping added to your project list or report.
    For more information about creating Groupings, see the article Groupings overview in Adobe Workfront.

  2. Go to an existing project view.

  3. Expand the View drop-down menu, and select  Customize View.

  4. Click  Add Column.

  5. Click  Switch to Text Mode.

  6. Mouse over the  Show in this column  area, and click  Click to edit text.

  7. Remove all text in the Text Mode box, and replace it with the following code:

    aggregator.displayformat=compound
    aggregator.function=AVG
    aggregator.namekey=view.relatedcolumn
    aggregator.namekeyargkey=actualduration
    aggregator.valuefield=actualDurationMinutes
    aggregator.valueformat=val
    displayname=Project Actual Duration
    durationunitfield=durationUnit.value
    linkedname=project
    namekey=actualduration
    namekeyargkey=actualduration
    querysort=actualDurationMinutes
    textmode=true
    valuefield=actualDurationMinutes
    valueformat=compound#M:D
    viewalias=actualduration
    
  8. Click Save View.

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