6 Replies Latest reply on Sep 26, 2018 5:38 AM by Shinichiro Murakami

    Calculate downtime between end and start date

    Numa Roch

      Hi,

       

      The structure of the data source is : one record for each reservation (ID reservation).

      I want to calculate the downtime for each car (Twizy) between the end date of the last reservation (which is on one row) and start date of the next reservation, which, for the same car, is on another row.

       

      I guess a Level-of-detail calc at the car (Twizy) level will do?

       

      Final goal : average downtime for all cars, rankings of downtime per car, total downtime etc.

       

      Many thanks in advance.

       

      Numa