Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have met a confuse about if function. There are 2 tables: 1 is my customer information, 1 is customers' order history.
I want a table show that customers who always order total bills' amount greater than 500 including total amout of each day. If in a random day that customer A order less than 500 although the other day's amount is greater than 500, his name wont be showed on table.
I have tried something as: if((count(if(aggr(sum(OrderAmount),Orderday,CustomerID))))=0, CustomerID). It works but cant excute for a big dataset. I dont have the right to edit in data load.
Could anyone give me an advise?
thank you guys so much?
Hi @theaokii ,
If I'm understanding what you want correctly this should work as your CustomerID dimension column:
Thank yo, Rodj,
I tried it firstly. And because of aggr orderday, the table shows customers have atleast 1 day order greater than 500.