Dashboard question regarding custom field and due dates

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.

1 Like

@Julien_RENAUD didn’t we have to deal with this ourselves?

Yes we already had this request, and it would be convenient even for us but I don’t have the solution in 1 graph.
The only solution is to have one chart per department, with the weeks for the X axis, and to choose the type of date to be taken into account (probably the due date).

1 Like