RE: 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.

raymondand4 Rookie Asked on November 5, 2020 in Saved Searches.
Add Comment
1 Answers
Best answer

I would be interested to know if you have tried putting this criteria onto the Summary subtab.

 

RE: Can I use a count or avg  function as criteria in saved search

Beginner Answered on November 5, 2020.

No, didn’t really know about that. It worked perfectly. thank you.

 

on November 5, 2020.

Sorry, I forgot one nuance. I  also checked “use expressions” so I could get order count > 5 OR average amount greater than $75.

on November 5, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.