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



      21Under Process
      31Send back to applicant
      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.