Report Aggregate Fields used in SQL Query

[JimHarbin]

In the list of fields that you can pick for a reports, aggregated fields (count, percent, etc..) are there.  How can I use those aggregated values in my report sql query?

i.e.  count(sourceaddress) is chosen in the field list.  I want my SQL query to be “count(sourceaddress) > 5” but when I try to use it it gives me an aggregated value error.  Are these aggregated values assigned to an alias that I can use in the SQL query or how do I constrain by report results based upon their value? 

The closest feature that I see built in is the “Return top X results” option, but that doesn’t give me the same end result.

[RSAAdmin]

You can't use those functions in your SQL Query.  I am sure that this has been raised as a Request for Enhancement, but you should also raise it...the more voices that are heard, the better the chance that it gets resolved

Paul

[RSAAdmin]

I have been trying to make this work myself using the count.

I have tried using a GROUP BY and HAVING with a SELECT in the WHERE clause and without the SELECT.

I agree, nothing works.

Glad to hear others require this functionality and thanks for posting.

Tracey