Problem

Need an average aggregate for the Project Actual Duration column so it rolls up correctly in groupings.

Solution

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