Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried everything, set analysis, aggr but i don't know where I'm going wrong
use firstSortedValue(), as below
=firstSortedValue(ID,-Date)
Why not just Max(Date)?
I.e, first column: Id, second column: max(Date) as expression
use firstSortedValue(), as below
=firstSortedValue(ID,-Date)
i tried but when i put more dimensions the id return more than one values
i tried but when i put more dimensions the id return more than one values
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
If you have more columns please attached the whole scenario.
@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;
Now i use the expression as a dimension and work it!