Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning ,
I have a table that contains ICAO , input date , achievement
I want for each ICAO to retrieve the last achievement that corresponds to the most recent date.
I want to get this last achievement for each ICAO, I tried the max ( input date ) and FirstSortedValue([Input Date], ICAO) the first one does not give what I want since in the group by I have to put ICAO and achievement and the second generation generates an error
Hi, as below.
Dimension: ICAO
Expression: FirstSortedValue(achievement,-[input date])
i tried this in the chart and it doesn't work
Share sample data and your expected results.
i want only the to get the achievement of 05-Jan-23
Aggr(Max([input date]), ICAO)
as below
=max ( TOTAL <ICAO> input date )