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.
Access requirements
You must have the following access to perform the steps in this article:
*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:
-
(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. -
Go to an existing project view.
-
Expand the View drop-down menu, and select Customize View.
-
Click Add Column.
-
Click Switch to Text Mode.
-
Mouse over the Show in this column area, and click Click to edit text.
-
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
-
Click Save View.