4 Replies Latest reply on Aug 3, 2016 6:57 AM by Oscar Lim

    Showing or displaying the date of the maximum value

    Oscar Lim

      I am wanting to show or view the date from where the highest processing time happened per Region. 

      The resulting table is shown below.  I am able to get the maximum value by using MAX(Process_Time).  However, I am unable to extract the corresponding date to show on the table.

       

      How do I get the date to show?

       

      Thank you for any help provided.

       

      Oscar

       

       

       

        Data set

      RegionDateProcess_Time
      East7/1/201624
      East7/2/201639
      East7/3/201648
      West7/1/201612
      West7/2/201644
      West7/3/201685
      North7/1/201626
      North7/2/201630
      North7/3/201628
      South7/1/201651
      South7/2/201635
      South7/3/201624

       

      Result

        

      EastWestNorthSouth
      Process_Time48853051
      Date7/3/20167/3/20167/2/20167/1/2016