Can I use a count or avg function as criteria in saved search
Answered
I was hoping to use this: CASE WHEN COUNT({number})>5 THEN 1WHEN AVG({amount})>75 THEN 1 ELSE 0 END
What I want is to know customers who ordered more than 5 times or had an average order greater than 75.
Best answer
I would be interested to know if you have tried putting this criteria onto the Summary subtab.
No, didn’t really know about that. It worked perfectly. thank you.
Sorry, I forgot one nuance. I also checked “use expressions” so I could get order count > 5 OR average amount greater than $75.
