Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

How can I create a report/chart that shows the cumulative back-log of projects (Active projects at the end of each month)

Avatar

Level 2

We have a report/chart that displays the project planned start date by month and the project actual completion date by month and we want also chart the differential between to the two that would be the cumulative backlog of projects by month. We need to be able to see if our backlog continues to grow where is becomes unmanageable.

Thank you in advance for any help.

John Weiss

Workfront Admin

Follett LLC

0694X00000Bzl16QAB.jpg

Topics

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

1 Reply

Avatar

Community Advisor

Hi John,

For this type of "time series", one approach (albeit manual) would be to create a special project called "Backlog Stats", add a zero duration Task for each month in which you intend to track stats with a Planned Start and Planned Completion that matches that month (e.g. "Jan 2020" would start and end on 1/1/2020, etc.), add a custom form behind each such Task where you can track (here's the manual part) the Number of Open Projects, Number of Closed Projects, and (as a calc) the Number of Open Plus Closed Projects. For cumulative charts, you could then add Previous Number of Open Projects, Previous Number of Closed Projects, and (again, as a calc) the Previous Number of Open Plus Closed Projects and (manually...you're getting the idea) fill in those values by looking at the closing values from the previous month, by computing (as calcs) Total Number of Open Projects, Total Number of Closed Projects, and Total Number of Open Plus Closed Projects.

Admittedly, that all takes some setup work and discipline to collect at The Right Moment, but as a result, you'll then have loads of chartable information with which to visualize your backlog trends (among other things).

And once that is all humming nicely, to remove the manual drudgery, you could then automate it with Fusion or our UberCalc solution.

Regards,

Doug