3 Replies Latest reply on Jul 13, 2016 7:43 AM by Luciano Vasconcelos

How to select latest record

Kian Hee Leow Jul 13, 2016 6:58 AM

Hi,

i have the following sample data

I am trying to explore doing the following

1) create a latest_contact field such that the output is as follows

ID	Modified Date	Contact	Latest Contact
A1	21/01/2016	123456	222222
A2	21/01/2016	456789	456789
A1	22/01/2016	147890	222222
A3	23/01/2016	111111	111111
A1	26/01/2016	222222	222222

I ran out of ideas how this can be done and so need to advice of experts here

Thanks in advance

1. Re: How to select latest record

Luciano Vasconcelos Jul 13, 2016 7:17 AM (in response to Kian Hee Leow)
Check if works to you.

Book1.twbx 16.7 KB
Like Show 0 Likes(0)

Actions
2. Re: How to select latest record

John Sobczak Jul 13, 2016 7:27 AM (in response to Kian Hee Leow)

Maybe this?: right(str({fixed [ID]: max([Modified Date Integer + Contact Integer])}),6)

where [Modified Date Integer + Contact Integer] = int([date])*100000 + int([Contact])
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: How to select latest record

Luciano Vasconcelos Jul 13, 2016 7:43 AM (in response to Kian Hee Leow)
This works.

Book1 (2).twbx 17.9 KB
Like Show 0 Likes(0)

Actions

Tableau Community Forums