Dimension, return the latest date

[Conor_Flanagan]

Hello Looker community,

I am trying to write a dimension (last meeting date) that will return the latest date from a dimension of dates. It’s for my sales team. I want the dimension to return the date of the last meeting a rep has set. So it would look like this:

Rep Meeting Date Last meeting date
Gary 3/14/17 2/10/18
Gary 5/20/17 2/10/18
Gary 5/27/17 2/10/18
Sean 8/11/17 1/30/18
Gary 2/10/18 2/10/18
Sean 1/30/18 1/30/18

I tried to do this with a max sql operator but couldnt get it to work. Any thoughhts on this?