Regarding requirement which is about resource report table to report genarate on user / group /role level we have genarated based on condition it running in my case
We have run the condition is report type is availability and entity type is group select particular group and start date and end date I have selected and report unit hours
Below screen shot to check it is wrongly caliculate the may month remaining months are as expected it's work
And another table is there group_resource_aggregate_monthly.list this table showing correct data below screen shot
