Filter by count (group by)

Filter by count (group by)

  

Hi there, 

I am using Count and ''group by'' in an aggregate as shown below: 



I would simply like to filter by Count (using a session variable), but the count attribute is not visible as an attribute in the filter area.

What am I missing? 

Cheers,

Cole 

Solution

Hi Cole,

You should select "Add Group Filter" instead of "Add Filter". Then the Count column will be availble:

Solution

Thank you. I had never taken note of that button!



You're welcome :). The "Add Filter" adds a "WHERE" clause to the query, the "Add Group Filter" a "HAVING".