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

    Select the max(datetime) for the same day

    Alan Buel

      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?