order result High to Low

[sdewar83]

I have a simple query, listing event codes by host:

index=wineventlog sourcetype=WinEventLog:Security
Stats count by EventCode, host

I'd like to order the results so that it shows either the top 10 highest count event codes (e.g 100 of 4625, 80 of 4264, etc) per host.
Or at least displays the count column in a highest to lowest fashion, per host. At the moment it displays all the info, but in no specific ordering. I'd like it to be more readily obvious which are the most common errors happening on hosts in t he time period i'm searching.

Any assistance appreciated!

[Sukisen1981 · Accepted solution]

so you add this - sort host,- count

[sdewar83]

perfect! worked like a charm.