Could someone explain why this expression isn't valid in the script.
if(max(UNIT.SOLD_DATE) > AddMonths(today(),-3), 'Active') as BUYER_BUYING_STATUS,
I'm trying to group buyers that have bought within the last 3 months if they have mark them as 'Active'.
Aggregations in the script like Max(UNIT.SOLD_DATE) need a GROUP BY clause.
Please provide script with sample data so that we can help you
Retrieving data ...