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.

Create aging report of Demand by State

Harish74
Tera Expert

Hi there,

I was asked to create aging report of Demand by State. What is aging report actually. I couldn't see any module like that in the instance.

Please help me in creating and let me know if this can be done with OOB.

2 REPLIES 2

Sulabh Garg
Mega Sage

Hello Harish,

Please check this community link, It will help you..

https://community.servicenow.com/community?id=community_question&sys_id=5a866e68dbb5f414b1b102d5ca96...

 

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

Please Mark ✅ Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

Hi @Sulabh Garg ,

I checked the community article you have shared. I created a Metric Definition for Demand State field. What should I do hereafter. I couldn't understand the highlighted points.

You'd have to use Metric Definitions.  You can look at the Incident ones and they'll give you a good idea of what to create.  Metric Definitions will create an "instance" on tracked fields and every time that field changes it will calculate the duration the field was a given value.

You create some Demand Metrics, then create a database view joining Demand to the Metric Instance table  for the demand metric instances.  Then you could have a report in the UI links or perhaps a related list that shows a project's metric instances for the given states.