Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Project open vs closed report

CV1
Tera Contributor

Hello All,

Looking for help to  build a  bar chart report in ServiceNow that shows the count of projects created vs. closed, grouped by different time intervals (Week, Month, Quarter, Year), using the Created Date and Actual End Date fields from the Project table (pm_project).

 

TIA

1 REPLY 1

SanjivMeher
Mega Patron
Mega Patron

This blog should help you achieve it

https://www.servicenow.com/community/platform-analytics-articles/opened-vs-closed-task-records-combi...

 

 


Please mark this response as correct or helpful if it assisted you with your question.