Forum Discussion

kasfour's avatar
kasfour
Helper I
3 years ago

Calculating Uptime

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 d...
Need Help
kasfour's avatar
kasfour
Helper I
3 years ago

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's avatar
v-jingzhang
Community Support
3 years ago

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's avatar
    kasfour
    Helper I
    3 years ago

    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