1 Reply Latest reply on Aug 10, 2016 2:40 PM by diego.medrano

    how to calculate time period for products in different stages???

    arnold.kumar

      Hello All,

       

      Am calculating the count of products that enter three stages based on the date

       

      I have Stage1,Stage2 & Stage 3 and Products, i need to calculate count of products by Date(Month) to show how many products are in each stage for a particular month.

      Using this i have to calculate "Total" & "Total Completed"

       

       

      Total - Total number of product is the number of product that is available for a particular month,

      Total Completed - It is based on the exit date of a particular product from one stage to another.

       

       

      Example : if Product A enter stage 1 on 26 November 2014 and be there till 28 November 2014 ,during this time period it falls on total category and when its exit

      that stage it must be total completed.

       

      Products           Stage           start date                               End date

      Prod A           Stage 1      3/5/2015 4:21:37 AM           3/5/2015 4:21:37 AM

      Prod A           Stage 2      5/29/2015 7:40:57 PM         3/5/2015 3:45:25 AM

      Prod A           Stage 3      3/6/2015 7:56:32 PM           3/5/2015 3:45:25 AM

      Prod B           Stage 1      3/5/2015 4:21:37 AM           3/5/2015 4:21:37 AM

      Prod B           Stage 2      9/22/2015 11:50:59 AM       3/5/2015 3:45:25 AM

      Prod B           Stage 3      9/22/2015 11:50:36 AM       3/5/2015 3:45:25 AM

      Prod C           Stage 1      6/18/2014 10:37:37 AM       6/18/2014 10:57:45 AM

      Prod C           Stage 2      2/20/2014 10:40:42 PM       2/21/2014 2:45:22 AM

      Prod C           Stage 3      11/17/2014 8:50:21 PM       2/18/2015 12:49:14 AM

      Prod D           Stage 1      10/10/2014 2:06:02 PM      10/10/2014 2:09:30 PM

      Prod D           Stage 2      10/10/2014 2:09:24 PM      10/10/2014 2:09:30 PM

      Prod D           Stage 3      5/22/2015 5:02:02 PM         5/27/2015 8:31:42 PM

       

       

      Please let me know how to achieve this

       

       

      Thanks in Advance,

      PK