Report that calculates Average Hours per project per job role

Hi Mollie, try the following and see if this is what you were looking for…

In an Hour Report, click on the Hours column (am assuming you are looking for actual hours -- this column is automatically added to an Hour Report when you start one), and choose “Summarize this column by:” --> Average.

For Groupings, select Project --> Name and then Job Role --> Name. Also be sure to add any Filters needed, so as to reduce the amount of data returned – e.g., Project Actual Completion Date.

Then, go to the Charts tab, and select either Column or Bar Chart. If selecting Column chart, the Left Y Axis would be Hours --> Hour and the Summarized by would be Average. The Bottom X Axis would be Project --> Name. Then toggle Group Columns On, and Group Data by Job Role --> Name. I would suggest choosing the Stacked Column option. Hopefully, the resulting chart is what you were looking for.