Calculating Uptime

[kasfour]

Hello,

        I am trying to have a dashboard that calculates each service's uptime. The issue is I cannot seem to find a way to divide the downtime against the operational time without having duplications if the date is repeated in the original sheet (ex: August 25).

To explain more, when checking August uptime the operational time is then found as 32 days instead of 31.

Appreciate your help if there is another way to do so . Thanks a lot.

[kasfour]

Can I calculate the difference between dates chosen in the Date slicer. If this is possible, I guess I will be able to get the uptime result in the end

[Stachu]

I do not see 31/32 days in the screenshot you attached, what are you refereing too? Also what is considered the operational time in this scenario? As for the duplicates - there are 2 dates for 25 Aug, but they are for different services, so as you mentioned that you want to calculate each service uptime I do not see how is that a problem, can you elaborate a bit more?

Also it would be great if you provided the example of input with both downtime & operational time and expected output (can be calculated manually)

[v-jingzhang]

Hi @kasfour 

Sorry I don't see operational time in your data. Can you explain what is / where is the operational time? And what is the logic to calculate the uptime based on downtime and operational time? I cannot understand the current data and expected result. Can you provide some expected output and calculation logic to help me understand this question better. 

Best Regards,
Community Support Team _ Jing

[kasfour]

This is the main dataset I have below, and then I have another table with the daily operational time. I then Merge both in a new table with the Date as a common column. 

[v-jingzhang]

Hi @kasfour 

If daily operational time is always 1440 minutes, you can divide downtime by 1440 directly. For example, 

Measure = divide(sum('Table'[Downtime]),1440)

If you want to calculate it for each service separately, you can add Service column to the same visual, then try measure

Measure = calculate(divide(sum('Table'[Downtime]),1440), allexcept('Table', 'Table'[Service]))

Best Regards,
Jing

[kasfour]

I see your point. However, the problem I am facing, is in the case I had two services down on the same day. So I log them in two seperate rows with the same date. So, in return the date is duplicated in the month range. Example date (8/25/2022) in the previous screenshot