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
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.