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.

Service Availability Report without using the Portfolio Management module

JulesG
Tera Contributor

‎10-08-2024 12:00 AM

is there a way for me to create a report by using like custom formulas and variables? The formula is simply:

 

((Service Hours - Downtime) / Service Hours)) * 100

 

Where:

  • Service Hours - Total number of hours in a given date range assuming a 24x7 availability
  • Downtime - Total duration of Major Incidents. In our case will be calculated using (Actual End Date - Actual Start Date)
  • Actual End Date and Actual Start Date - are custom fields within Incident Table
0 Helpfuls
  • 475 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎10-08-2024 06:16 AM

You might check the Commitment modules for same.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls