The Timeline view in the base has great resource utilization functionality that isn't yet available in the interfaces. I'm wondering if there's a good solution for using a chart to demonstrate utilization over time without having to go into the core base.
Full Context
My company uses Airtable as our primary work management system - we assign employees to tasks, which have estimated times to complete (as we bill our clients hourly for work). I'd like for our operations team to be able to easily see how much work an employee has day-to-day within a given time frame. In our base, tasks have a start and end date. I can use a WORKDAY_DIFF() formula to return the number of days a task is scheduled to take, and then use a simple division of the overall time value by that number to get the hours per day the task takes. The intention here is to roughly estimate how much work the employee has to do (i.e. the sum total of work assigned shouldn't exceed 8hrs a day per employee to accomplish)
While the Timeline view can accomplish this natively, most of our ops team prefers to work out of Interfaces. Ideally, I would use a chart to demonstrate an employee's estimated workload over time, but charts require date data that exists in a field and (at least as far as I know) won't recognize the inferred dates that exist between the start and end of a task.
For example - if an employee is assigned a 3-hour task on Monday that is due on Wednesday, and a 3-hour task on Tuesday that is due Thursday, I'd like to be able to graph that their workload Monday through Friday is (M) 1hr - (T) 2hr - (W) 2hr - (Th) 1hr- (F) 0hr. Instead, I can only demonstrate the total amount of work on the due date, so the graph looks more like (M) 0hr - (T) 0hr - (W) 3hr - (Th) 3hr - (F) 0hr.
This might be tenable if the framing is "this is the amount of work the employee has to complete within a timeframe," but breaks down in usefulness if there are larger and longer-term tasks, as it then looks like the employee has weeks with nothing on their plate.
Has anybody else tried to build out a similar interface? What solutions have you come up with for this?
