Expand my Community achievements bar.

Possible to aggregate a calculated column?

Avatar

Level 6
I created a task report that shows the kickoff date, the date of SOW signature (a custom field used in a project-level form) and a column calculating the number of days between the two (code below). The report is grouped by PM. I need to show the average number of days from SOW signature to kickoff. Any suggestions on how to do this since I'm working with a calculated column? displayname=Days from SOW to Kickoff textmode=true valueexpression=DATEDIFF({actualCompletionDate},{project}.{DE:PDS | Date SOW Signed}) valueformat=int Catherine Hayes The Channel Company
5 Replies

Avatar

Community Advisor
Hi Catherine, The Advanced Reporting course mentions the concept of "https://support.workfront.com/hc/en-us/articles/217145078-View-Column-Project-with-Average-Actual-Duration-Aggregated-in-Grouping">Calculated Aggregates , but according to "https://support.workfront.com/hc/en-us/articles/115000497647-Calculated-Custom-Data-Vs-Calculated-Columns">Calculated Custom Data Vs. Calculated Columns , "when you want to aggregate the data beyond the aggregation that is calculated in the field", Workfront recommends you (instead) use a Calculated Custom Data field. Doing so also lends itself to charting, advanced column highlighting, etc. which could also be beneficial, so I'd also recommend the latter. Regards, Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Avatar

Level 10
Hi Catherine, I do similar calculation - i've got Calculated column created which calculates for me Duration of Approval path. I've got it grouped within the report as i needed average duration for projects. Below the code i use. aggregator.displayformat=doubleAsString aggregator.function=AVG aggregator.valueexpression= WEEKDAYDIFF({approvalStartDate},{approvalCompletionDate}) aggregator.valueformat=HTML displayname=Duration of Approval textmode=true valueexpression= WEEKDAYDIFF({approvalStartDate},{approvalCompletionDate}) valueformat=customNumberAsString Change highlighted for your calculation and that should be working for you as well :) oh and change displayname for yours :) Dagmara Garwell BAKKAVOR LTD

Avatar

Level 6
Thanks @Doug Den Hoed Unfortunately in this case, I can't use a custom calculated field because I'm comparing a custom field date against a timeline or task date. Catherine Hayes The Channel Company

Avatar

Level 6
Thanks very much @Dagmara Garwell this worked. I appreciate the help :-) Catherine Hayes The Channel Company

Avatar

Level 10
No worries Catherine, glad it worked for you :) Dagmara Garwell BAKKAVOR LTD