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.