4 Replies Latest reply on Apr 4, 2018 3:49 AM by jagadeesh T

    Count distinct record if longer than 120mins

    Kelvin Yeo

      Hi folks,

       

      hope to hear your suggestion

       

      my sample dataset

        

      Ticket number Open Time
      104/03/2018 12:11
      204/04/2018 15:26
      204/04/2018 15:26
      304/04/2018 16:26
      404/04/2018 17:49
      404/04/2018 17:49
      504/04/2018 21:30

       

      Assuming the time now is 04/042018 22:00

       

      I would like to count the distinct number of tickets which had exceeded 2 hours of 'Open Time'

      In this case, it should gives a result of 4 distinct tickets (because ticket 1,2,3,4 had exceeded 2 hours of 'Open Time')

      Ticket number '5' is not matched because it has not exceeded 2 hours of 'Open Time'