2 Replies Latest reply on Sep 5, 2018 5:13 AM by Zhouyi Zhang

    Total Time a Product was Online

    Goncalo Alemao

      Dear all,

       

      I would like your help.

      I need to do an analysis on how long several products were online and for that I'm displaying my database format bellow:

       

      Brand
      Status
      ProductDate
      Column I Need - Total time Online per Product

      A

      OnlineX01-01-20002+3 (3-1 + 10-7)
      AOnlineX07-01-20002+3 (3-1 + 10-7)
      AWaitingX05-01-20002+3 (3-1 + 10-7)
      AOfflineX03-01-20002+3 (3-1 + 10-7)
      AOfflineX10-01-20002+3 (3-1 + 10-7)
      AOnlineY01-02-20004+2 (5-1 + 10-8)
      AOnlineY08-02-20004+2 (5-1 + 10-8)
      AWaitingY06-02-20004+2 (5-1 + 10-8)
      AOfflineY05-02-20004+2 (5-1 + 10-8)
      AOfflineY10-02-20004+2 (5-1 + 10-8)

       

      So, basically want I would like to have is a column with the sum of all the date between Online and Offline.

      However there is also some status called waiting that is when the product is awaiting to be approved to be Online again.

       

      Thank you so much for your help!

       

      Best regards