Stats Command

Use this command to provide summary statistics, optionally grouped by a field. The output for this query includes one field for each of the fields specified in the query, along with one field for each aggregation. Syntax Note:While the eval command creates new fields by using existing fields and arbitrary expressions, the stats command calculates statistics based on existing fields. stats "("")" [as new_field_name] [by (,)*] Parameters The following table lists the parameters used with this command, along with their descriptions. Parameter Description field_name Use this parameter to specify the field according to which you want the results to be grouped. Functions The following table lists the functions available with this command, along with their examples. Function Examples Values values(field_name) values(Label) values(Severity) values(‘Client Host City’) values(‘Client Host Country’) values(‘Client Host Continent’) Unique uniqu...