5 Replies Latest reply: Nov 9, 2017 10:08 AM by Sunny Talwar RSS

    Calculate average lead time

    DANIEL ARAUJO

      Hi!

       

      I have got a table similar to the format below in which I need to calculate the average lead time (finish date - start date) in a certain period of time (activities finished in the last 7 days, in the last 14 days and so on).

       

      IDSTART DATEFINISH DATE
      130/10/201706/11/2017
      201/11/201708/11/2017
      201/11/2017
      08/11/2017
      303/11/201707/11/2017
      403/11/2017
      505/11/201710/11/2017
      505/11/201710/11/2017

       

      Please note 2 points:

      • the id might repeat
      • only the ids already finished (finish date is not null) should be taken into account

       

      Can someone help me?