Capacity vs Demand Chart

Hello,

We are beginning our journey with Workfront and would really like to get some stronger and more detailed insights from the resource planner.

What we would like to see is a 18 month window (6 months historical, 12 months forecast) of our demand (what is planned out for our particular team) showing where that time is being spent, maybe a program, portfolio and project level grouping. [Area Chart]

Combined with this is the actual hours submitted for the last 6 months again grouped in the same way. [Bar Chart]

Over the top, we would like to see how many hours we have available for FTE's [Red Line] and Contractors [Blue Line]

This then maps out as per the example:

With that chart being dynamic, and us using a project template, we can then get a strong view for the demand that we are being asked to deliver and the capacity to actually deliver this.

In the new resource planner you do have a majority of the items required to build this report. and I think this chart should take place above the table view, like the agile burn down charts.

Thanks