Need help on Chart Report - Showing each Job Role FTE total (Stacked) per working week.

What specifically are you showing on the y-axis? Is it accumulated assigned hours for a particular job role?

Hi Greg, Ideal would be FTE so we could see totals of each job role required per week. Thanks, Linden

Sorry, in looking at this closer, I don't know how to do a report showing by week the number of hours planned per job role. Hopefully someone else will pipe in.

Thanks anyway, Greg. Can you recommend any types of chart display reports that will demonstrate similar behavior?

Unfortunately I cannot. Hopefully someone else can.

What you are looking for is very easy to do in Excel. I haven't figured out how to get a stacked bar chart out of WorkFront though. Are you interested in producing it in Excel?

Lucas, If it’s impossible to produce somehow in WF, Management will review a report from Excel - providing the data comes from WF. I’d love to know what type of data report you’re producing in WF along with how you set this up in Excel. Thank you! -Linden

Hi: In the attached Word doc, I have the Group Matrix report that creates the data. Then, export the Matrix report into Excel. Then build a stacked bar chart on the data, per the attached example. If you have a lot of roles, the graph is going to get busy. Be advised this report uses the Resource Estimate object. To create this object, go to the Business Case, Resource Estimate, select the resource pool, and set the budget to schedule. If you’re not sure how to create the resource estimate object, let me know, I’ll send more details. Thanks! Eric

If there was a "Like" button for this, I'd click on it. :-)

Just FYI... I added this to the Reporting filebase in the Resources section of the Community. In Reply to Greg Beck:

If there was a "Like" button for this, I'd click on it. :-)

-Nate Bagley --- Workfront Community Manager - Work Smart, Work Happy Message me directly at: