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

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'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