Skip to Content (Press Enter)
UserImage.jpg
Cole Noble
620Views
3Comments
Solved
Filter by count (group by)
Question
SQL

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 

0
0
16 May 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Solution

Hi Cole,

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

2
0
16 May 2018
Copy Link
UserImage.jpg
Cole Noble

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



0
0
16 May 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

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

2
0
16 May 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.