Report for Open Projects at a point in time.

[CarinneCr]

Hi all,

I’m trying to build a report that shows how many projects were open/active at a specific point in time (for example, how many were active on January 1st, 2024).

The issue I'm running into is that filtering by status only gives me the current state of the project. That means I’m missing projects that were active at that time but are now complete or dead. The only other data I have to work with are the start and end dates, and I'm not sure how to use those to create a snapshot for a past date. It would be nice if we could group my month but I'm open to manual changes or prompts to get the data for each month. 

Has anyone figured out how to approach this kind of reporting in Workfront?

Thanks in advance!

[_Manish_Singh]

Hi @CarinneCr - Workfront reports don't support time series analysis, they only show the current state. For time series analysis, you'll need to use alternative tools like Snowflake, which can handle historical data.

[Lyndsy-Denk]

Considering @_Manish_Singh's point, you could workaround it by using the automatic delivery function for the report. Most of the options send an attachment, which is basically the snapshot of the data at the time of send. Of course, that doesn't help if you want to look at the data as it was in the past.

[Edwin_Melgar]

You could potentially back into this through the report filtering.   Rather than filtering on status, pull a list of reports that have a project actual completion date > [Date] 12am and project actual start Date < [Date] 12am.