Summarizing Column Values on a Report | Community
Skip to main content
KayleeRichard
KayleeRichard
Level 2
January 15, 2025
Solved

Summarizing Column Values on a Report

  • January 15, 2025
  • 1 reply
  • 546 views

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? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

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.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
January 15, 2025

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.

    Terms & ConditionsAccessibility statement

    Loading footer...