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
  • 342 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