6 Replies Latest reply: Mar 15, 2018 4:45 AM by Caroline Huet RSS

    calculate WIP by comparing dates

    Caroline Huet

      Hello,

       

      I would like to calculate the Work in Progress for my products so I would need to compare dates.

       

      My table is :

       

      IDDateDate type
      110/03/2018beginning
      212/03/2018beginning
      313/03/2018beginning
      115/03/2018end
      218/03/2018end
      320/03/2018end

       

      I would like to draw a line chart showing the number of product that are between the beginning and the end date in function of generic dates. So I will have the number of product in the production line in function of dates.

       

      Do you think I have to rearrane my table to do that ?

       

      Could you please help me ?

       

      Best regards,