Report Aggregate Fields used in SQL Query
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.
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
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.