after using the initial group of columns detected in the case statement up top (e.g. any numerical columns), i want to add a couple other different column aggregates. it seems like adding another item re-runs aggregation on all current board columns or something similar because i get duplicates of all the first aggregated numerical columns.
example above, when trying to run a “first” or “collect” operation on the string column it doubles my total number of output columns adding the shown prefix to all of the aggregates from first operation
for posterity, the desired behavior isn’t supported with aggregate multiple columns, need to manually do it using regular aggregate function.
1 Like