Group Recipe - Custom aggregation (ranges)

clbfkp

Is it possible to calculate ranges in the grouping recipe? Currently, I am using the provided max and min aggregation and taking the difference in a subsequent prepare step, but it would be easier to calculate it directly as part of the group recipe especially as the number of columns grow.

I'm getting an error when I try to create my own custom aggregation but my SQL is both limited and pretty rusty. Any help or links would be much appreciated.

MAX('colname') - MIN('colname') (Error: column "custom_aggr_1" is of type double precision but expression is of type text)

Turribeach

You should use the column names without any quotes otherwise you are asking the max() function to return the max of a text type which is why you get the error you get.

MAX(colname) - MIN(colname)

clbfkp

Thanks!