Report for Open Projects at a point in time. | Community
Skip to main content
C
CarinneCr
April 29, 2025
Question

Report for Open Projects at a point in time.

  • April 29, 2025
  • 5 replies
  • 559 views

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!

    5 replies

    _Manish_Singh
    _Manish_Singh
    Level 9
    April 29, 2025

    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
      Community Advisor
      Lyndsy-DenkCommunity Advisor
      Community Advisor
      May 1, 2025

      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
        Edwin_Melgar
        Level 4
        May 9, 2025

        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.

          MegSVT
          MegSVT
          Level 4
          June 17, 2025

          Ahh, I am currently trying to build this exact report. Do you have any updates or were you able to find a workaround to this??

          kautuk_sahni
          Community Manager
          kautuk_sahniCommunity Manager
          Community Manager
          July 29, 2025

          @carinnecr Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

          Kautuk Sahni
          Terms & ConditionsAccessibility statement

          Loading footer...