How to calculate % availability

Hi all: I need to measure availability (uptime) of systems and countries. Results change based on filters (time span, system selected, etc). I have the numerator: the sum of hours of downtime bas...

Need Help

walterdp

Helper I

3 years ago

Hi marcelsmaglhaes

Thanks for replying. Not sure if I was clear enough when explaining the problem.

What I need to do is to calculate availability with number of hours of downtime in a given period of time divided by total number of hours in the same given period of time. That period should be flexible (filtered by a visual object)

I've tried something similar to what you've mentioned, but I believe I'm not doing it well.

Here's the formula

Disponibilidad 3 = CALCULATE (1 - DIVIDE(SUM('Incs Cerrados'[Time to Restore]) --Sum of all downtime
,DATEDIFF(MIN('Calendario'[Date]),MAX('Calendario'[Date]),HOUR),1)) -- Calendario is a date table.

Here are the results

Creada (Start Date) is the field in "Inc Cerrados" table that's used as the filter to define the period of time mentioned before
Total Tiempo is the denominator of the division mentioned above (DATEDIFF(MIN('Calendario'[Date]),MAX('Calendario'[Date]),HOUR),1))) This field should change when modifying filters