Below GSQL code require in one line

1

@markmegerian @Jon_Herke
I am trying to apply where condition after POST Accum in one line) but this is giving me an error on where condition, I want to do it in one line. Can you please help
profiles_spend = select s from all_profiles:s-(profile_purchase:e)-Orders:t-(order_items:ee)-Products:tt ACCUM
s.@total_spend +=ee.item_qty*tt.item_price, s.@distinct_weeks+=t.week_id
post-ACCUM s.@avg_weekly_spend = s.@total_spend/s.@distinct_weeks.size() where s.@avg_weekly_spend > 3000 and s.@avg_weekly_spend <= 4000;

But it works in two different variables
profiles_spend = select s from all_profiles:s-(profile_purchase:e)-Orders:t-(order_items:ee)-Products:tt ACCUM
s.@total_spend +=ee.item_qty*tt.item_price, s.@distinct_weeks+=t.week_id
post-ACCUM s.@avg_weekly_spend = s.@total_spend/s.@distinct_weeks.size();

  prof = select s from profiles_spend:s where s.@avg_weekly_spend > 3000 and s.@avg_weekly_spend <= 4000;
  PRINT prof;
2

Change the WHERE to a HAVING clause, since it runs after the post-accum

2 Likes
3

@markmegerian
Its working
Thank you so much for your help
Really appreciated

1 Like
4

Yes it simple, Because the HAVING clause is then applied to the rows in the result set.