8 Replies Latest reply on Aug 13, 2018 1:03 PM by Carlos Esparza

    Showing the last data of a table

    Carlos Esparza

      Hi.

       

      I have a table just with the date in the format (day/month/year hour:minutes:seconds) and a value.

       

      For example

       

        

      Adq DateValue
      13/07/2018 2:1378
      13/07/2018 9:2468
      13/07/2018 14:3667
      13/07/2018 20:2269
      14/07/2018 1:5971
      14/07/2018 7:1284
      14/07/2018 12:1574
      14/07/2018 17:1073
      14/07/2018 22:3575
      15/07/2018 4:3877
      15/07/2018 11:05100
      15/07/2018 15:45100
      15/07/2018 19:46100
      15/07/2018 23:58100
      16/07/2018 4:18100
      16/07/2018 8:5761
      16/07/2018 13:3163
      16/07/2018 18:1870
      17/07/2018 0:4772
      17/07/2018 6:5767
      17/07/2018 12:1474
      17/07/2018 17:3674
      18/07/2018 0:0778
      18/07/2018 5:54100
      18/07/2018 11:1678
      18/07/2018 16:2776
      18/07/2018 22:2377
      19/07/2018 4:3177
      19/07/2018 9:3576
      19/07/2018 14:1574
      19/07/2018 20:3975
      20/07/2018 2:0874
      20/07/2018 9:2875
      20/07/2018 13:5763
      20/07/2018 18:4463
      20/07/2018 23:3663
      21/07/2018 4:5863
      23/07/2018 2:0164
      23/07/2018 7:1665
      23/07/2018 12:4761
      23/07/2018 18:0663
      23/07/2018 23:4868
      24/07/2018 5:5175
      24/07/2018 10:4666
      24/07/2018 15:3566
      24/07/2018 21:2870

       

      The data will be updated every 10 minutes, and  I need to display just the last data of the column value of the table. When the data start a new day, all the previous days should display just the last data of that day, maybe can be a data at 23:59:00. For the present day I need to show the last data received. In the table above asuming that the last data is from the present day, for example, the display should be like this:

       

      Encabezado 1Encabezado 2
      13/07/2018 20:2269
      14/07/2018 22:3575
      15/07/2018 23:58100
      16/07/2018 18:1870
      17/07/2018 17:3674
      18/07/2018 22:2377
      19/07/2018 20:3975
      20/07/2018 23:3663
      21/07/2018 4:5863
      23/07/2018 23:4868
      24/07/2018 21:2870

       

      I'm trying with the forum "Mostrar solo el ultimo registro", and with these links "Mostrar solo el primer o el último valor de una partición" and "Filtrar la vista para mostrar solamente el valor de fecha máximo de cada categoría" but I can't

       

      Can someone help me?