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:



      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?