We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Service Availability Report without using the Portfolio Management module

JulesG
Tera Contributor

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
1 REPLY 1

Dr Atul G- LNG
Tera Patron

You might check the Commitment modules for same.

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************