Aggregate + first or Last value

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

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)

A post was split to a new topic: Keep both min and max in one “Keep min/max” action