Hi there! In SQL, there is a clause “HAVING” which can filter aggregated results on the same query level.
For instance, I want to see each customer and their amount of sales (say, group by customer and count sales), but I only want to see customer which made more than one purchase (that is, count sales per customers HAVING more than one sale).
Is there a way to perform that on metabase?
Of course, I can use sub queries, or saved questions, and so on, but I’m trying to achieve that considering the average non tech user.