Hello,
From our ERP system I have data on:
[Resource Name] (Machine Centre)
[Project Name]
[Start Date]
[End Date]
# of [Hrs of Work] required
I am trying to make a stacked bar chart that shows each day, with a slicer to filter per [Resource Name], showing which projects are being processed on on the days shown.
Right now I can make a stacked bar with all of the work showing up on the [End Date], but what I need to do is divide the [Hours of work] between the [start date] and the [end date], thus showing how much work is to be done on each project per day.
Thanks,
Solved! Go to Solution.
@nick_SMTC , refer if the blog or my file on similar topic attached after signature can help
@nick_SMTC , refer if the blog or my file on similar topic attached after signature can help
Thanks amitchandak,
I was able to get the solution to work with some fine tuning. Top graph is what I had before and bottom graph is what I was able to cut it into in terms of daily resource use. Much appreciated!!
Thanks amitchandak, got the date table working but having trouble with the formulas to assign a volume of work per date. Will continue to work on.