6 Replies Latest reply: Oct 13, 2012 9:04 AM by SHERI CAMPBELL RSS

    Count from last timestamp?

      How do you create an expression to get a count of last timestamp of ID for each LEVEL and RISK from the table below?

       

      TIMESTAMPIDLEVELRISK
      7/23/2012126496
      7/24/2012128895
      7/24/2012135726
      7/24/2012135726
      7/24/2012183316
      7/25/2012136626
      7/26/2012122294
      7/27/2012122236
      7/28/2012288926
      7/30/2012288926
      7/31/2012677726

       

      I would expect to get the following counts:

      LEVEL=1 RISK=6 ====> COUNT=1

      LEVEL=2 RISK=6 ====> COUNT=4

      etc...