Need help with a formula indicator for calculating overall uptime for MTBF

[Susan Tickle]

We are trying to calculate a general uptime by using the number of minutes in a month minus the downtime. For the uptime formula indicator we were hoping to utilise the function (score_end.getDaysInMonthLocalTime() * 1440), however this does not work as there is nothing for it to calculate against.

Does anyone have a suggestion?

[JP - Kyndryl · Accepted solution]

Hi Susan,

Check the last reply in this thread:

https://community.servicenow.com/community?id=community_question&sys_id=312941b4db6aa7806c1c02d5ca961947

Regards.

JP

[Susan Tickle]

Thank you JP, unfortunately this doesn't work, I have tried using various count indicators at the beginning of the formula, but none are calculating the value.

We are not specifying certain applications in the measure, we need to be able to show total time available as the total number of minutes in each month, then we can calculate the uptime as (total time minus downtime)

It may be that we need to look at creating a script that will calculate how many minutes in each month and use that

[Mark Nguyen]

Hi @Susan Tickle ,

I am attemping to create a formulla Indicator for MTBF. Did you have any luck with this endeavor? 

[rkreddy11]

How Can I create a MTBF Report in the context of Dynamic Reporting?
The calculation will involve subtracting the resolution date of one incident from the creation date of the next incident.

ex:

Time between incident 1 and incident 2:
From 3-9-2023 10:15 AM(resolved on) to 18-9-2023 17:25 PM (created on)
15 days and 7 hours

Time between incident 2 and incident 3:
From 21-9-2023 10:15 AM to 24-10-2023 17:25 PM
33 days and 7 hours

Time between incident 3 and incident 4:
From 27-10-2023 10:15 AM to 31-10-2023 17:25 PM
4 days and 7 hours

Now, let's calculate the average of these time intervals:

(15 days + 33 days + 4 days) / 3 = 52 days / 3 ≈ 17.33 days

So, the Mean Time to Failure (MTTF) for these incidents related to the API failure is approximately 17.33 days.


So, In SNOW Reporting How can I achieve this?