5 Replies Latest reply on Sep 6, 2017 9:40 AM by Jennifer VonHagel

    Display one row based on one field

    Andrew Hillyard

      Hi

      Is anyone able to help with this query

       

      My data is as follows:

       

      Time        Yesterday   Today

      09:00      100,000     120,000

      10:00     105,000     121,000

      11:00     110,000     127,000

      12:00     120,000

      13:00     130,000

      14:00     140,000

      15:00     141,000

       

      I want to create a filter that results in the data only displaying one row, the row where all data is populated, in the above example it would be the 11:00 record,

       

      Time        Yesterday   Today

      11:00     110,000     127,000

       

      and is dynamic so when the 12:00 record appears it shows that line instead

       

      The 'time' is a character field, rather than a datetime.

       

      thanks.