I have this working for another client and I can do a demo for you. It's not so easy to do, but I did manage to do it without script (ie all native QuickBase). The issue is that to make a chart, the chart needs entries for each time period, say each week or each month depending on what you want. My client wanted resource planning by week to schedule Technician Labor required vs labor available. The labor available was hand entered into a table, in their case they have 6 technicians, so the one of the lines on the line chart was the available labor - basically 6 man weeks of labor per week. Then we added in vacation or PTO and that decremented the available labor by week. ie if 1 of the techs was expected to be off next week, then that week would show a dip to just 5 man weeks of available labor per week. That was the easy part.
The fancier part was to create the weekly entries of the labor required per Job, for each week that the Job was active.
The result was actually a beautiful chart which highlighted Labor needs vs Labor available, but week. They were then able to visualize problems ahead of time and immediately rescheduled some jobs to not create situations which which were either going to be impossible to meet, or would have caused a ton of overtime. I suppose, that as business picks up they can also visualize the need to hire another tech if no amount of job rescheduling will solve the labor needed.
So it can be done, but its not something that can be explained on this forum as the setup, while native, was complicated. Contact me via the information in my profile if you would like a demo.
