How to create a summary report around multiple projects? | Community
Skip to main content
D
DaBell
Level 3
May 16, 2023
Solved

How to create a summary report around multiple projects?

  • May 16, 2023
  • 1 reply
  • 684 views

I need to create a summary report by Program (customer).  This Report is to provide statistics about each Program's projects?

 

I don’t see a Program report.  How to I build a report that summarizes multiple Projects?

 

For instance, I need to create a report that displays:

  1. Actual duration (days) = Sum of all project’s Actual Duration (task start and task end) - minus days a project may have been on hold (by Program). 
  2. Average Leadtime (days) = Actual duration / number of Projects (by Program)
  3. Percent on time = % of Projects whose Actual Duration <= Planned  Duration (by Program)

Any guidance would be greatly appreciated.

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

The path that I would take to build a report initially would probably be a Project report grouped by Program

1 reply

Richard_Carlson
Community Advisor
Richard_CarlsonCommunity AdvisorAccepted solution
Community Advisor
May 16, 2023

The path that I would take to build a report initially would probably be a Project report grouped by Program

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity Advisor
    Community Advisor
    May 17, 2023

    Agree, I came to comment the same thing. Definitely a project report grouped by program. If you only see Program ID as a grouping option @dabell , you can change your grouping to text mode and replace 'ID' with ':name' to give you program name.

    If this helped you, please mark correct to help others : )
      Terms & ConditionsAccessibility statement

      Loading footer...