Availability Percentage calculation on the Outages table.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-25-2023 05:32 AM
Hello All,
We have a requirement where we need to calculate monthly, quarterly and yearly percentage availability of the outage by minutes.
For example,
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