So I just set up a way of looking at how many labor hours per department I’m projecting to happen in the Dashboard. This is for a manufacturing environment. I’ll tell you what I did, and then ask you how I can improve what I did.
All my departments are represented by a Section in the project that is populated with tasks (manufacturing tasks). Each Task has a custom field filled in called “Labor Hours”.
I then set up a Dashboard chart showing my Departments (Sections) against the Labor Hours (Custom Field) and I set the due date for “Within the next week”. That’s beautiful, it calculates all my projected labor hours and graphs them perfectly.
However, I’m looking for a way to set it so that I can see specifically “next week only”, “3rd week out only”, “4th week out”, and so on, up to 6 weeks total.
I cannot just use the “due within the next 2 weeks” because it will combine this week and next week. I just want to see “Next week”.
I know I can just set the charts up and manually edit the date ranges once a week, but that’s a lot of poking. Is there a way to set it up so that it automatically shows those future weeks?
I’ve included an image of my “due within the next week” chart just for help.
Also, I retyped this whole question because I don’t think my original wording made a lot of sense.