I want to create a capacity heat map in ZOHO. The first step was to develop this query (below) to determine the "Capacity Start Date" , "Hours p/Day Remaining", and "Scheduled End Date." Now that I have all that, I want to create a new query that will essentially reference the one below, but spread those "Hours p/Day Remaining" across all the days between "Capacity Start Date" and "Scheduled End Date" by the Department, Network ID, etc. Site

Any suggestions on the next step?