3 Replies Latest reply on Nov 27, 2018 4:10 PM by Yuriy Fal

    Select the max(datetime) for the same day

    Alan B

      Hello tableau community,


      I try to have the oldest datetime for each day listed in my sources (a row corresponding to a snapshot), and then give the value of a field at that time.


      For example:


      if I have a line like this


                  DATE              |     STATUT   |

      30/11/2018 10:54:55              A

      30/11/2018 18:50:20              B

      30/11/2018 12:15:45              C


      31/11/2018 11:56:44              A

      31/11/2018 10:44:35              B


      I will have to return the B value for day 30 and the value A for day 31.


      Can anyone help me with that?