Hi, thanks for the tip, I'm looking for the average over ALL of the projects though and not per project. I need to sum the hours by role for each project and then divide by the total count of projects. Not any easy thing to do in WF. :-(

The timeline is NOT SOON ENOUGH! 

Hi Chloe, Thanks for this. Unfortunately I don't think I can search down an object and all the dates that I want are in the project level and all named the same thing :-) I confirm with Workfrotn support that this can't be done, but I did learn it will be able to be done in New Workfront Reportin...

Hi, Has anyone figured out how to create a program level report that summarizes status, overall percent complete, final planned completion, etc? Much like the stat's that are seen on the program page but are not visible as fields for reporting? AND does anyone know how to create a calculated fiel...

Thanks for the reply. Sounds like I will have to go with the matrix hours report plus a project report. Mollie

Hi Monique, Did you ever figure out a solution for this? I'm looking for something similar but hours filtered by job role or team or group. Thanks! Mollie

Does anyone have any magic to create a bar graph that would show average hours per project by job role?

This is common in other software, it really should be in WF as well.

Hi Csengi, That's the thing about collections; they can't be individual lines. It's a one to many relationship between programs and projects. I don't know of any other way to show it. -Mollie Mollie Shatek, PMP M +1 303 204 3000 **Click HERE<> to enter a Workfront Help/ Change/ New or Modified ...

Hi, To do that you would need to use text mode for a collection in your program report something like:displayname=Projects in the Programlistdelimiter=<p>listmethod=nested(projects).liststextmode=truetype=iteratevaluefield=namevalueformat=HTML Hope that helps. Mollie