How do I average a column in a report?

[MeiganRe]

I have a custom column in my report that shoes the number of days each task is in the New status: valueexpression=WEEKDAYDIFF({entryDate},{actualStartDate})

I want to average this column so I can see the average number of days it takes to pick up a task.

I've been reading about aggregate values in Workfront reporting but I can't figure out how to implement it in a way that will show the average for a bunch of tasks.

[Richard_Le_ · Accepted solution]

Hi Meigan,

The below text mode will allow you to display the average within the grouping header of your report view

aggregator.function=AVG

aggregator.namekey=datevariance

aggregator.valueexpression=WEEKDAYDIFF({entryDate},{actualStartDate})

aggregator.valueformat=HTML

description=Days in New Status

displayname=Days in New Status

namekey=datevariance

textmode=true

valueexpression=ABS(WEEKDAYDIFF ({entryDate},{actualStartDate}))

valuefield=dateVariance

valueformat=HTML

Best Regards,

Rich.

[NRYNR]

Hi Meigan, please have a look at the WFPro Text Mode Examples to see how this is accomplished. https://wf-pro.com/textmode/text-mode-views/#average-weekdays-to-complete

[MeiganRe]

Thanks, Narayana. I have been working through the WFPro examples but I'm just not good at the text mode!