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

[Colin Iveson]

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 · Accepted solution]

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

[Community Alums]

Hi @Colin Iveson ,

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Dhiren Aghera]

Hi Colin,

If you follow/ensure to submit the weekly progress of the project via a status report then it actually captures the percent complete at that point of time. If you look at the status report related list then you should be able to see the weekly % complete progress. 

Other alternative is to use performance analytics and create indicators which will capture the required information based on the decided frequency and will be plotted as a trend over a period of time.

Hope this helps.

[Colin Iveson]

Hi,

Thanks for the reply, I do appreciate the help and my apologies for not getting back sooner.  

I have tried this and maybe not got it correct,  but if I miss a weekly update,  ( maybe going on leave for a week)   the graph goes to zero for that week.  

Is this correct or have I done it wrong ?