# Generate "work load" view per team member? **URL:** \ **Category:** Ask the Community\ **Created:** [January 22, 2020, 11:28am UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399 "2020-01-22T11:28:57Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 22, 2020, 11:28am UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/1 "2020-01-22T11:28:57Z")
Hi! Newbie here… I’m trying to set up a project planner tool for us to use at our agency. I have gotten so far that I can easily create projects with different tasks and assign team members to these tasks, but what I do not know how to do is set up data / a view where I can see a team members project allocation over time. In an ideal world, this would probably show what projects, per project and total allocation, for each team member on any given day. I’m open to suggestions though 😃 Here’s what I got so far: https://coda.io/embed/Faw_RV_cWn/_suHNc?viewMode=embedplay ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 22, 2020, 11:29am UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/2 "2020-01-22T11:29:47Z")
Also, what’s up with that teeny tiny add row + sign in the gantt? 😃 ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 23, 2020, 3:38pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/3 "2020-01-23T15:38:42Z")
No ideas? If one could generate a one-row calendar for each team member, with project allocations per day, that ought to do it, but I don’t know how. Or if one could, somehow, visualize each projects “timeline” and allocation for each team member? ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [January 23, 2020, 5:33pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/4 "2020-01-23T17:33:30Z")
@Stefan_Singer hey thanks for sharing the doc that really helps. Can you advise what do you mean by the ‘project allocations per day’? What are wanting as and result? An integer? ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 23, 2020, 5:37pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/5 "2020-01-23T17:37:16Z")
Yup, percentage. If you look at the team tab, you can see that each member can get assigned to a project task by x% allocation, then in the Project Tasks table, I use the sum for that to calculate the duration of the task. ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [January 23, 2020, 5:50pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/6 "2020-01-23T17:50:49Z")
OK a few things. Assignments should be in its own section, I wasn’t sure what that was referencing and its hiding below Team. What table do you want this new value to be in? And what is the math (use your words to describe what you want to do and I’ll help with the formula) you want it to show? You have the curse of knowledge in terms of what a ‘load’ is and an ‘assignment’ etc. ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 23, 2020, 6:44pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/7 "2020-01-23T18:44:34Z")
I’m hearing you 🙂 Load is workload. If you’re, on any given date, assigned to two projects, 50% assignment on both, your workload (load) is 100%. This should maybe go in a new table, with a row per day and columns fetching assignments per user and total workload (sum of this days assignments) per user. Maybe something like that would work? Not sure how to visualize the data afterwards, but it could be a step in the right direction. edit: moved assignments into own section ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 23, 2020, 8:04pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/8 "2020-01-23T20:04:33Z")
I’ve added a “workload lab” section and am actually making progress 🙂 ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [January 23, 2020, 8:09pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/9 "2020-01-23T20:09:14Z")
Shouldn’t Load be an attribute of each Task? Then you can see what tasks are assigned to each user and `sum()` the load of those tasks? ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 23, 2020, 8:26pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/10 "2020-01-23T20:26:22Z")
You mean in the actual tasks table? Then no. One person can be full time assigned to task A and another at 40% on the same task A. ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [January 23, 2020, 8:33pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/11 "2020-01-23T20:33:01Z")
OK but how does Coda or anyone know how much each person has of each task? ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 23, 2020, 8:46pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/12 "2020-01-23T20:46:18Z")
It says so in the Assignments table 🙂 ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [January 24, 2020, 3:25am UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/13 "2020-01-24T03:25:32Z")
@Stefan_Singer ok I think I understand. This what you’re looking for? ![total load](https://global.discourse-cdn.com/coda1/original/2X/a/af0417efccffdd918869b9393fe00b4ac7e6f616.gif) ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 24, 2020, 5:44am UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/14 "2020-01-24T05:44:29Z")
No, sorry, that does not give me any “per day” info, but I think I know how I could do it in the “workload lab” section. I’ll do some tests during the day (I just woke up, with new ideas!). ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 24, 2020, 1:36pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/15 "2020-01-24T13:36:39Z")
Could not get all the way, look at the Workload Lab section, I don’t know how map all team members, I’d need nested CurrentValues the way I’m trying to do it… ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [January 24, 2020, 3:55pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/16 "2020-01-24T15:55:38Z")
I’m still not clear on what you’re trying to get … You want ‘per day’ load? To be calculated and shown where? ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 24, 2020, 3:57pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/17 "2020-01-24T15:57:55Z")
Yes. In the workload labs table. But I might have a solution thanks to @Paul_Danyliuk now. ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 25, 2020, 8:04pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/18 "2020-01-25T20:04:33Z")
I’ve managed to generate the data now, in the Workload Lab section, using this formula: ``` Sequence(1, thisRow.Members.Count()).FormulaMap( List(thisRow.Members.Nth(CurrentValue), thisRow.Members.Nth(CurrentValue).Assignments.Filter( AND(Start<=thisRow.Date,End>=thisRow.Date) ).Load.Sum() ) ) ``` But I’d like to see a (stacked bar or area or whatever works) graph with the work load for each member over time, is that possible? ![image](https://global.discourse-cdn.com/coda1/original/2X/c/c0a387a3d47b98ae3545f8f142f4c289b35e728e.png) ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [January 28, 2020, 5:05pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/19 "2020-01-28T17:05:34Z")
Hmm maybe make a control dropdown for member select + table with set dates and then have the table calc the figures you want for the selected member and then plot that? ---
**Author:** ![Stefan\_Singer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_singer/32/12491_2.png) [@Stefan\_Singer](https://connect.superhuman.com/u/Stefan_Singer)\ **Post date:** [January 28, 2020, 5:54pm UTC](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399/20 "2020-01-28T17:54:33Z")
Thanks! The issues here being that there aren’t unique rows per member, I think I maybe have to generate the graphing table based on the workload table… [Next page](https://connect.superhuman.com/t/generate-work-load-view-per-team-member/13399.md?page=2)