4 Replies Latest reply: May 2, 2016 1:24 AM by Feras Alsuhaibani RSS

    Calculate Duration of a Subset

    Feras Alsuhaibani

      Hello Everyone!

       

      So I have this huge table, and in this tables there are different kind of statuses of an application. For example, App with ID: 1 has the following statuses

       

       

      IDApplicationIDStatus
      11New
      21Under Process
      31Send back to applicant
      41Updated
      51Finished
      62New
      72Under Process

       

       

      So what I'd like to calculate is the average of time it takes the employees to complete assigned tasks (take the time when it is finished - the submission time), but I have to exclude any application which has not reached a specific status. For example, in the example above Application2 should be excluded.

       

       

      Your help is really appreciated.

       

      Thanks!