Beastmode | All seperate rows instead of one summed row

user046467

I've the following beastmode:

case when DATEDIFF(Select Columns.Date,Date) >0 then sum(Select Columns.Totaalprijs)/COUNT(DISTINCT Email) else 0 end

But instead of one row I get multiple rows.

I tried adding 'sum' to other places in the beastmode but I'm receiving either an error or the same result.

Can someone shed a light on this? Thanks 😁

GrantSmith

try putting g your case inside your SUM statement:

 sum(case when DATEDIFF(`Select Columns.Date`,`Date`) >0 then `Select Columns.Totaalprijs` ELSE 0 END)
/COUNT(DISTINCT Email)

You're evaluating each row one at a time with the case statement outside of your aggregation which is why you're getting multiple records.

GrantSmith

try putting g your case inside your SUM statement:

 sum(case when DATEDIFF(`Select Columns.Date`,`Date`) >0 then `Select Columns.Totaalprijs` ELSE 0 END)
/COUNT(DISTINCT Email)

You're evaluating each row one at a time with the case statement outside of your aggregation which is why you're getting multiple records.

user046467

Ahh I see, thanks that works!