DocumentationWorkfrontWorkfront Guide

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

Last update: Tue May 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

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