Expand my Community achievements bar.

Plotting planned hours over time

Avatar

Level 2

I am trying to figure out if there is a way to plot the planned hours of a project over the life of a project. Like the Utilization info will give you, but for the life of the project. (The Utilization chart is limited to a week or a month and I can't export the data to Excel to recreate the chart.) I would love to see just one project but it would be great if I could layer project on top of project to see how they all stack up. But let's start with the first baby step.

Does anyone know how to plot the planned hours vs. the day or week of the project for the entire life of the project? Hours on the y-axis and weeks on the x-axis. It would also be great if I could export the data.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

23 Replies

Avatar

Level 10

Hi Matt,

That is a tricky challenge, but our Capacity Charts solution handles all that, and more, plotting Capacity, Planned, and Actual hour (x-axis) over time (y-axis) for whatever timespan and measurement you choose (eg 1 year, by week), accounting for schedules, time off, roles and people, for as many Projects as you choose (via filters), grouped and stacked as you see fit (eg by Role, by Project), rendered in real time from right within Workfront, with a leading “thumbnail” summary, followed by full page individual charts and an optional data table, and downloadable as pdf or Excel.

Regards,

Doug

Doug, this looks great. Pretty much exactly what I need, but the price is way out of my range. I am going to have to see if I can find a different solution. Thank you again. I will keep his in mind if my organization grows big enough to be able to afford a tool such as yours.

Avatar

Level 4

Hi Matt,

great question - we also need a different view for the planned hours. Could this view be helpful to you?

0690z000009D2m3AAC.jpg

Here used in a project dashboard:

0690z000009D2lyAAC.jpg

Avatar

Level 3

I can never figure out how to get the dates to appear on the X axis! Do you mind sending a screen shot of the graph setup? Thanks!

Avatar

Level 2

Manuel, thank you for your help. That chart would work fine but I need to know how WF distributes hours for longer tasks. For example, if I have a task that is 60 hrs. and 3 weeks long, and I create a report like the one you showed but with hours grouped by week, is it going to show 20 hours per week? Is it going to show 60 hours in the first week? Or the last week?

The information is in WF and is displayed in various ways. You can see it in the utilization tab on a project. You can see it in the resource planning. You can see it in some of the new analytics. But I can't get to it with a report. I just need to get the total number of hours for any give day/week/month for a project.

Do you know how WF distributes the hours for longer tasks?

Avatar

Level 4

Unfortunately, Workfront puts all hours to the beginning of a task.

That’s why Doug proposed to use it only for short tasks. As workaround, we asked our users to split tasks when they exceed a month to be able to get monthly reports.

Avatar

Level 2

Manuel,

I might be able to get what I need from the Resource Planner if I export the data to Excel. Do you know if the Planner lumps all hours to the beginning of a task? I certainly hope not.

Avatar

Level 4

The resource planner calculates the distribution of the hours over time. Unfortunately, the functionality cannot be used in normal reports as far as I know.

The Excel workaround is fine, but it undermines the transformation into real time data usage instead of number crunching in Excel.

Manuel, I am impressed that you convinced project managers to break their tasks into tasks of one month or less. I would have expected resistance to the extra work; especially if a plan then moves (say, by 2 weeks), since those tasks would then have to be adjusted to realign the planned hours. If you could elaborate on what you’re doing to manage (or avoid) such changes, and how you are using your charts, I would be interested to learn more. Matt, leaving the charting aspect aside for a moment, it sounds like your main requirement is planned hours per week/month/year by person (or role, or project; with the other two aspects shown “beneath”, eg by person/role/project) over a long timeframe (eg a year), presumably in real time (eg as planned dates move, change and stretch), and (ideally, I’d expect) accounting for schedules and personal time off ‚Äî all without you having to export that data and perform those calculations. In that case, our Resource Contouring solution would handle all of that, and you could even download it to Excel periodically if you did want to do some charting. If you would like more information, you are welcome to email me at doug.denhoed@atappstore.com Regards, Doug

Avatar

Level 4

It's a constant fight to cut the tasks in pieces which limits project management usability.

Doug, let's connect - I'd love to jointly find a better solution.

Avatar

Level 10

I'd be happy to, Manuel -- please email me at doug.denhoed@atappstore.com.

Regards,

Doug

Avatar

Level 4

It's a task report with the following details:

0690z000009D3prAAC.jpg0690z000009D3q1AAC.jpg0690z000009D3qGAAS.jpg

Avatar

Level 2

Manuel, thank you for your reply. Unless I am misunderstanding, this will still group hours to the planned start date.

If I have a task that is 40 hours and 5 days long, I want the report to show 8 hours a day not 40 hours on the planned start date..

Avatar

Level 4

Unfortunately, you are absolutely right :-( All information I got from Workfront indicates that only the native planner view allows to cut down the tasks. I'd love to find a way here, as the planner doesn't fit our needs.

Doug's solution is excellent, albeit expensive.

Avatar

Level 2

Yes, Doug's solution is exactly what I am looking for. However, my organization is small and can't afford it. I have had some luck exporting data from the resource planner and working with it in Excel using pivot tables. It is a very manual process and a bit messy, but I am encouraged by what I am finding. There is a feature suggestion HERE if you want to go comment and vote for it.

Avatar

Level 10

Thanks for the details, Manuel: that approach works well for tasks with short (i.e. <1 day) durations, since the Planned Hours will all be "lumped" into either the Start Date or End Date, depending on which you've decided to Group By (Planned Start Date, in your case). To avoid double-counting Summary Tasks, I also recommend filtering to only numberOfChildren = 0 assuming that those "leaf / bottom / child" Tasks is where the Planned Hours are configured.

Matt and Sara, if your Tasks are mainly of a short duration (and/or close enough), Manuel's technique might be all you need; but if your Tasks are longer and you need the concept of having the time "spread" throughout the duration, you could either try an Assignment report (provided you assign all tasks, ideally 1:1 to a single role and user), or as I'd mentioned above, consider our Capacity Charts solution, which handles all that and more (e.g Schedules, % Role apportionment, PTO, etc.)

Regards,

Doug

Hi Doug,

great remark! Indeed, the task duration remains an issue for our solution. In our case, the have a monthly tasks for each user and do monthly reporting.

I love your Capacity Chart add-on, it's the perfect solution! However, the pricing makes it interesting only for a high number of users.

Does anyone have some more information about the Assigment Report? I don't find much information about it and don't manage to bring months/weeks to the x-axis.

Doug, that is good advice. I have run into the double counting problem before and always check for children tasks when I create these types of reports. I haven't tried an assignment report. I will have to look into that. We have many long tasks in our projects that require the spreading of hours.