Add aggregation to AGGREGATE action

Feature requests
1

Add the following option FIRST to the possible aggregation choices.

This will set the first value of the group for the column defined. I am not sure if ANY does this. So groups containing multiple rows would be guaranteed to have the FIRST value of the aggregated column .

2

You can already do that with other actions:

  1. Use the "Enumerate rows" with the "Enumerate in groups" option. For grouping, use the same columns that would be used for aggregation.

  2. Use the "Filter" action to only keep rows where Rowno = 1.

3

Thank you