Availability Percentage calculation on the Outages table.

rohit_murli
Tera Contributor

Hello All,

We have a requirement where we need to calculate monthly, quarterly and yearly percentage availability of the outage by minutes. 

For example, 

 

bindu_jayagond_0-1682425710330.png

Here we are considering all the dragonfly items as one configuration item. Now, we need to check whether the dates are overlapping or not. If not then we should get the gap of the days(from 1st record to 2nd).And then calculate the total availability of the CI for month, quarterly and yearly.

May I know what condition I should use to get the overlapped days and gaps in between dates and then calculate the total availability of the CI for month, quarterly and yearly by minutes.

Thank you.

 

0 REPLIES 0