Can I select multiple columns in Snaplogic and perform a min/max/avg on them? I've attached a picture below. I would like to select data from 1960-1963 and find the avg/min/max for the specific country.
Yes.
Way 1 :
Use the Aggregate snap with the math function of your choice.
Way 2 :
Use the < platform > - Execute snap (eg, SQL Server - Execute) to write your own query which includes these math functions. This is great if you need CASE statements.
