Moment in Time / Snapshot report??

Forum|Forum|1 year ago
November 22, 2024
2 replies
1117 views

Hello! I'm looking to build a Work in Progress report for our Marketing dept. They're looking for monthly "snapshots" of what projects were In Progress during each month. Not the month they started, not the month they finished, but an overall "In Progress".

An example would be a project may have started in March and completed in June. We would want that project to show up in March, in April, in May, and in June.

We are talking about a LOT of projects, so listing out the individual projects on a chart-style report is not an option - ideally it would be a bar chart showing work in progress by month. Here's an example:

Let me know if I can clarify further!

Thank you.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Madalyn_Destafney

Community Advisor

Hi there, my first thought was a baseline report, which captures what the project was when it started vs any other time you decide to capture its state. More on baselines here. But if you're looking for something more high level, could you just do a project report grouped by status? You're capturing the status they're in dynamically, so if it shows 30 are in progress today but are completed tomorrow, they'll show with the completed bar tomorrow. You could add another grouping and choose a stacked bar chart, like what you have here. So could be projects by type and status (or owner and status, whatever makes sense for your use case) and group by those 2 things, then use those in a stacked bar chart.

If this helped you, please mark correct to help others : )

amybillmayerAuthor

Level 4

Hi Madalyn - I will definitely check out the baselines. Hopefully that's what I'm looking for.

Unfortunately, we're not looking for a dynamic report that will change as the projects are completed. We want to be able to look at everything that was being worked on in any given month, or across multiple months.

Thanks for your speedy reply!!

Madalyn_Destafney

Community Advisor

What if you use tasks instead. Could make a task report grouped by project. In the chart, group it by project name and planned completion by month to see which projects show MoM that had tasks due (ie they were in progress at that time). Then you can show same projects repeatedly that may span more than one month…

If this helped you, please mark correct to help others : )

skyehansen

I think the problem is that for Workfront reporting, the same object can't show up over and over. You can't run a project report and then expect to have that project show up 4 times from March to June. While Workfront briefly dabbled in offering an Analytics section that did more, I don't think they've moved forward with it. You should probably ask @doug_den_hoed__atappstore if he has anything you can use.

amybillmayerAuthor

Level 4

Oh! Great suggestion Skye, thank you!

skyehansen

you're welcome. The only other thing I can suggest is that you can have different reports, like a March report, April report, May report, and so on, and then report on which projects were being "worked on" in that month. You can't simply say "which projects were in progress" -- it would have to more be "which projects had changes in tasks, issues, files, or time" but you get the point, which is that you can get the numbers but you can't get a pretty chart (that would be more on Doug).

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded