How do I create a report to show project completion over time please?

Colin Iveson · ‎07-11-2022

I want a report to show projects progress over time. I can get project percent complete at a given point in time but not to show progress over weeks or months.

Is the history of project percent complete stored in a ServiceNow table that I can use for reporting?

Or, do I need to export percent complete weekly for each project and build the report outside ServceNow?

I've looked through previous posts and forums but can't find a solution for this.

Community Alums · ‎07-11-2022

Hi @Colin Iveson ,

As the project task contains the relation to project ,the easiest way to build a dashboard is to base all reports either on the project task table ( and use dot walking to get the project details) or build a database view doing the same (connecting project & project task tables).

Your concerned tables would be :

pm_project ( project table)
pm_project_task (project task table)
planned_task_rel_planned_task (task relationship table)

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

View solution in original post

Dhiren Aghera · ‎07-21-2022

Hi Colin,

The % complete for the project can't become zero if you don't create a status report for one week but will be the same as previous week. You can always keep track of the progress once you are back and update the % complete so that it will reflect correctly.