Subquery SQL during dataprep

[Bunnydata]

Hi @Sanjeeb2022 , my data is stored in RedShift.

I did post the exact requirement here trying to use calculated field but unable, so I try to use SQL. The solution provided in this question does not work.

Calculate average with condition

Hi @Bunnydata to that you can try: Select “Add Calculation” from the dropdown menu. Enter a name for the calculated field (e.g. “Avg Sales First 3 Months”). Use the following formula: IF(OR({Month of Sales}=1,{Month of Sales}=2,{Month of Sales}=3),AVG({Sales Amount}) OVER (PARTITION BY {Product} ORDER BY {Month of Sales} ROWS BETWEEN 2 PRECEDING AND CURRENT ROW), “”) This will create a new calculated field that shows the average sales of the first 3 months for each product. If there are no …