group data by max of one column

[HAMID_AKBARI]

I need to expression in a table which group rows by max of a column.

The result need to show the latest "Description" which is filled in the biggest "stage".

Thank you Q cmmunity

[Pierrick]

Hello @HAMID_AKBARI,

You can do a table with ID like a dimension, and measure : FirstSortedValue(Description,-Stage)

FirstSortedValue is a function that allows you to retrieve the first value of a column according to a certain sort order.

Have a good day !

[Chanty4u]

Try this 

FirstSortedValue(Description, -Stage)

Or 

FirstSortedValue(DISTINCT Description, -Stage)

Or 

FirstSortedValue(Description, -

Stage, 1)

[HAMID_AKBARI]

It dosent work,in fact the data contains one work order to many childs(stage).

in every stage there is User,Date,and Description ...

now i want to see the final status of the table which contain last User,Date and desciption,,,also ther is a Delay duration that calculate time between every data registerd.

thank you

[AndrzejD]

for example:
data:
load
ID,
FirstSortedValue( Description, -Stage ) as Description
group by ID
;
load * Inline [
ID, Stage, Description
1014, 1, Text1
1014, 2, Text2
..
Andrzej