Is there a way to extract the resource Working Hours to total the weekly hours
eg. if Working hours is set to 9 to 5 for 5 days a week, that would be 40 hours for Week 42
I want to reference this in the booking entity so I can chart utilisation eg. Weekly Booking Hours is 30 and Work hours is 40, so a Utilisation of 75%
I hope to do this in a Chart but could also use Power BI if I can access the data
Thanks
Dave