Calendar Time Report

Hi everyone,

I have two tables and i am trying very hard to figure out how to plot this on a column / line graph over time.

I need to show the demand of hours on projects against the resources calendar of how many hours a day they can work.

I have the information in 2 separate tables, but i am struggling to show "blank days". Like if a resource has no work on for a particular day i need to see the chart show zero hours . If need a column chart to show say zero for 01/02/202 as his capacity is 8 but he has no project work

What is best way to do this ?

Table 1 has all my resource detail (target utilisation, hours per day required to work which is capacity)

Table 1: Resource Information

Table 2 : Resource Project Assignments