Aggregate + first or Last value

[Filvog]

Hi,

Just one question, with aggregate function, when we use aggregate function, I want to have the first or the last value from one culum sorted with the date. I see that we can sum, min, max… but i don see the possibility to use the first or last record.

Do you have one typ to do ?

In the picture above, for the 01/01/2023 I want to use the first record 10 or the last record 14

Thanks for helping

[dgudkov]

You can use the “Enumerate rows” action to enumerate rows for each date. Then use the “Keep min/max” action for the row numbers grouped by dates. “The smallest 1” mode will return you the first value, “the biggest 1” - the last one.

See the example below:
first-in-group.morph (3.7 KB)