How to calculate mean in GROUP BY node

I wanted to find the mean after grouping the external id. But I can’t seem to find “mean” in the aggregation list under manual aggregation. Now, they are all listed and I want to find the mean of the list. What should I do?

‘Mean’ is only there if your column is a numerical column. Try the String to Number node before your GroupBy -



Thank you!! I did it

1 Like