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

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:

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront plan Any
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 permissions Manage 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:

    code language-none
    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.

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