Expand my Community achievements bar.

Got questions about Workfront Governance? Join our upcoming Ask Me Anything session on February 12th!
SOLVED

Summarizing Column Values on a Report

Avatar

Level 2

Hi, I have a task report with a column that is calculating the turnaround time of the task: 
displayname=Turnaround Time
textmode=true
valueexpression=IF(ISBLANK({actualCompletionDate}), "", CONCAT(WEEKDAYDIFF({handoffDate},{actualCompletionDate})))
valueformat=HTML

The report is grouped by month and the team would like to see the Turnaround Time AVERAGE summarized per month without having to export the report into excel and use a formula to find the address there. Is this possible? 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

I don't believe this is possible whilst you are using a calculated column in your report view. Calculated columns calculate data in real time and they only exist in the view itself, the calculations are not stored anywhere for Workfront to be able to aggregate into an average or sum.

 

What I would recommend is building a calculated field that is attached to each of your tasks. This way the turnaround time value will be stored for each task and will be available as a field to use in reports. The benefit is that aggregations can be applied to the field (to work out the average) and it will also be available for use in visualisations such as bar charts (which can't be done with a calculated column).

 

Best Regards,

Rich.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi,

 

I don't believe this is possible whilst you are using a calculated column in your report view. Calculated columns calculate data in real time and they only exist in the view itself, the calculations are not stored anywhere for Workfront to be able to aggregate into an average or sum.

 

What I would recommend is building a calculated field that is attached to each of your tasks. This way the turnaround time value will be stored for each task and will be available as a field to use in reports. The benefit is that aggregations can be applied to the field (to work out the average) and it will also be available for use in visualisations such as bar charts (which can't be done with a calculated column).

 

Best Regards,

Rich.