5 Replies Latest reply on Jul 11, 2017 2:42 AM by Rajeev Pai

    Date Difference between 2 dates in the same column (using local and published datasource)

    Rajeev Pai

      Hello Everyone,

       

      I have a table with incident ID and some other information in my local database (say sheet2). But I am required to calculate the Date Difference from assigned time to finished time (This information is present in published datasource - sheet1 and I dont have access to modify the datasource).

       

      In the published datasource, the data is in below format.

       

        

      IncidentStatusDate
      ACreated6/1/2017
      AAssigned6/2/2017
      AWork In Progress6/3/2017
      AFinished6/4/2017
      ACompleted6/5/2017
      BCreated6/6/2017
      BAssigned6/7/2017
      BAssigned Again6/8/2017
      BWork In Progress6/9/2017
      BFinished6/10/2017
      BCompleted6/11/2017

       

      For example lets say I want to calculate the % of incidents whose days difference between assigned to finished was less than 3 days. In my sample data, there are 3 incidents with days difference less than 3 days. It has 4 records. Now I need to show only 75% as the output in the sheet and nothing else. Can anyone help me. The published data source contains many records.