How to show latest status of maximum date as expression?

[mrichman]

Hi Community,

I was wondering how you guys would approach the following, in a straight table + expression?

I have a straight table with ClientID, Date, Status and I would only like to see Clients with the maximum date and current status. However, im getting the other data too. This would make it difficult for me to export to excel.

Current:

Astrida 2018-05-25 1

Astrida 2018-05-26 2

Astrida 2018-05-30 3

Betacab 2018-05-25 1

Betacab 2018-05-27 3

Betacab 2018-05-30 2

Canutility 2018-05-24 2

Canutility 2018-05-25 1

Canutility 2018-05-29 3

Ideal Solution:

Astrida 2018-05-30 3

Betacab 2018-05-30 2

Canutility 2018-29 3

Data:

LOAD * inline [

Customer|Date|Status

Astrida|2018-05-25|1

Astrida|2018-05-26|2

Astrida|2018-05-30|3

Betacab|2018-05-25|1

Betacab|2018-05-27|3

Betacab|2018-05-30|2

Canutility|2018-05-24|2

Canutility|2018-05-25|1

Canutility|2018-05-29|3

] (delimiter is '|');

Thanks in advance!!

[tresesco]

Dimension: Customer

Exp1: Max(Date)

Exp2: FirstSortedValue(Status, -Date)

[YoussefBelloum · Accepted solution]

Hi,

try this if you want to keep your dimensions on the table:

=if(Date=Max(TOTAL <Customer>  Date),only(Status))

[mrichman]

Thanks, it worked.

[mrichman]

Thanks this worked better than the recommendation above. !

[YoussefBelloum]

you're welcome, good luck