Do you have any preference for the actual layout of the visualisation ? ... maybe you can work back from there to get the data in the correct format (if you're able to do that).
Are you after traffic-lighting of utilisation or something else ?
Thanks for your response!
I don't have a preference, although I was thinking heat map or traffic-lighting, yes. I want a visual queue to alert viewers when an employee is at, over or approaching workload capacity.
I'm just not really sure how to figure out capacity in a 35 hour work week. I'll have to build a calculated field for it I'm sure.
I have the following fields:
Section name (team)
Number of files assigned to an individual
Sum of logged hours in each file by each individual
file start date
File Closed date
Calculated file duration field
Did you ever find a solution?