24 Replies Latest reply: Jun 15, 2018 12:16 PM by Michael Befkadu RSS

    How to show latest data by area

    Michael Befkadu

      Hello,

       

      I have data uploaded by clients daily showing RAG status. Data entered is not always complete therefore I would like to build a straight table showing the latest submitted RAG status by area. Can you please help how I can do this at the front end.

       

      Here is the data I have at the moment

          

      AreaDate and TimeData
      B5/2/2018 10:47:27Amber
      C5/2/2018 10:47:27Red
      D5/2/2018 10:47:27Amber
      A5/3/2018 10:40:00Black
      C5/3/2018 10:40:00Black

      E

      5/3/2018 10:47:00

      Green

      A5/4/2018 12:27:05Amber
      E5/4/2018 12:27:05Green
      B5/4/2018 12:27:05Black

       

      And this is what I would like to Display

       

      AreaDate and TimeData
      A5/4/2018 12:27:05Amber
      B5/4/2018 12:27:05Black
      C5/3/2018 10:40:00Black
      D5/2/2018 10:47:27Amber
      E5/4/2018 12:27:05Green