6 Replies Latest reply on Aug 2, 2018 1:40 AM by Malene Fangel

    Downtime for equipments

    Malene Fangel

      I have to make a report, where I calculate the downtime for some equipments.

       

      The data set I am working with, could look like this:

       

      Test.PNG

      Where each row is a fault, and the difference between StartTime and EndTime will be defined as downtime.

      In this case, I want to define the downtime for proces A as the downtime for ID 3 and 4 and for ID 1 and 2, the downtime should only be from 00:00:00 to 00:02:55.

       

      For now I am using {FIXED StartTime: DATEDIFF('second', StartTime, EndTime) }, but that does not solve my problem.

       

      Can anybody help me?