How to get the latest operation result in a table

[aguirre]

Hello,

I have a table with the following data:

timestamp	task	result
17/10/2024	task1	OK
18/10/2024	task1	OK
18/10/2024	task2	KO
18/10/2024	task2	OK
19/10/2024	task2	OK
19/10/2024	task2	KO
20/10/2024	task1	KO

I would like to show a table with the latest results only for each task:

task	LatestResult
task1	KO
task2	OK

Which formula should I put on column LatestResult ?

[CHRIS_Singa]

Group by task and LatesResult

And then use where condition to filter the timestamp

[Kushal_Chawda · Accepted solution]

@aguirre  try FirstSortedValue()

=FirstSortedValue(distinct results, -timestamp)