topic group data by max of one column in App Development

group data by max of one column

HAMID_AKBARI — Fri, 11 Jul 2025 09:20:34 GMT

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

Re: group data by max of one column

Pierrick — Fri, 11 Jul 2025 09:37:01 GMT

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 !

Re: group data by max of one column

Chanty4u — Fri, 11 Jul 2025 11:22:33 GMT

Try this

FirstSortedValue(Description, -Stage)

FirstSortedValue(DISTINCT Description, -Stage)

FirstSortedValue(Description, -

Stage, 1)

Re: group data by max of one column

HAMID_AKBARI — Sat, 12 Jul 2025 16:31:03 GMT

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

Re: group data by max of one column

AndrzejD — Sun, 13 Jul 2025 08:48:26 GMT

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