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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.