Forum Discussion
How to unevenly distribute values between two dates
Hello, I am trying to create a visual showing the planned workloads of projects between the start and end dates, however the hours are not evenly distributed across the project timeline.
Here is the data that I have
I have a table showing the project type, total hours and start and end dates
| Project ID | Project Type | Start Date | End Date | Weeks | Total Hours |
| 1 | Small | April 3, 2022 | May 1, 2022 | 4 | 15 |
| 2 | Small | April 10, 2022 | May 8, 2022 | 4 | 10 |
| 3 | Medium | April 10, 2022 | June 19, 2022 | 8 | 50 |
| 4 | Large | April 10, 2022 | July 24, 2022 | 10 | 75 |
I have another table that shows how much of the total time is distributed for each week of the project depending on the size of it
| Week | ||||||||||
| Type | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Small | 25% | 50% | 25% | |||||||
| Medium | 25% | 20% | 20% | 5% | 5% | 5% | 10% | 10% | ||
| Large | 15% | 10% | 10% | 10% | 5% | 5% | 5% | 5% | 15% | 20% |
I would like to create a visual showing the number of hours per week per project. I am able to make this visual when the total value is distributed evenly between the start and end dates but I can't get the distribution to be uneven. Any help on this is much appreciated!
2 Replies
- lbendlin
Super User
Your small projects have a duration of four weeks but the weighting table only has three values. Please provide sample data that more accurately covers your issue.
- v-luwang-msft
Community Support
Hi Anonymous ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.Best Regards
Lucien
