7 Replies Latest reply on Jan 31, 2016 5:35 PM by Randy Adhitama Setiadi

    Get the lastest value from the same ID

    Randy Adhitama Setiadi

      Hi,

       

      I'm newbie at tableau. I have a problem to get the lastest value from certain ID:

       

      This the example of my case:

      IDEventID
      Date
      Value
      1E1Nov-134
      E2Nov-157
      E3Nov-184
      2E4Nov-143
      E5Nov-132
      3E6Nov-186
      E7Nov-172
      4E8Nov-201
      5E9Nov-216
      6E10Nov-198

       

      I was wondering how can we getthe value from the lastest date if an ID have more than 1 eventID. So for this example we should get:

      IDEventID
      Date
      Value
      1E3Nov-184
      2E4Nov-143
      3E6Nov-186
      4E8Nov-201
      5E9Nov-216
      6E10Nov-198

       

      sorry i can't give the original data because of the privacy matter, hope you all can understand.

       

      Thanks

       

      Randy