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

Last update: November 4, 2024

CREATED FOR:

  • User

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

project_with_aggregate_actual_duration_in_grouping_view.png

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.

Display project Actual Duration aggregated by the average in a grouping

To add this column to a project view:

  1. Go to a project list.

  2. (Required) To see the aggregated average value of the project’s Actual Duration, you must have a grouping added to your project list.
    For more information about creating groupings, see the article Groupings overview in Adobe Workfront.

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

  4. Click Add Column.

  5. Click Switch to Text Mode, then click Edit Text Mode.

  6. Remove all text in the Edit 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

  7. Click Done, then Save View.

  8. (Optional) Update the view name, then click Save View.

Previous pageView: add a list of task successors in a column
Next pageView: combined task and issue details in an Hour list

Workfront