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.
Access requirements
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:
Current:
|
| 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:
-
Go to a project list.
-
(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. -
Expand the View drop-down menu, and select Customize View.
-
Click Add Column.
-
Click Switch to Text Mode, then click Edit Text Mode.
-
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 -
Click Done, then Save View.
-
(Optional) Update the view name, then click Save View.