How ot pick the id with the lasted date

[DataHashira]

I tried everything, set analysis, aggr but i don't know where I'm going wrong

[AronC]

Why not just Max(Date)?

I.e, first column: Id, second column: max(Date) as expression 

[vinieme12 · Accepted solution]

use firstSortedValue(), as below

=firstSortedValue(ID,-Date)

[DataHashira]

i tried but when i put more dimensions the id return more than one values

[DataHashira]

i tried but when i put more dimensions the id return more than one values

[vinieme12]

Can you please post the expression you tried ?

Are you trying this in chart or data load editor?

The expression I provided is for chart usage

[AronC]

If you have more columns please attached the whole scenario.

[AronC]

@DataHashira Do you have to solve it frontend.

Otherwise in backend you could just flag the rows with latest date. Then your set-expression would be very smooth.

left join(Orgiginal_Table)
ID,
max(Date) as Date,
1 as _LatestDate
resident Orgiginal_Table
group by ID;

[DataHashira]

Now i use the expression as a dimension and work it!