show table results in descending count order

[bcusick]

Hi,

I'm thinking this has a simple solution..Is there anyway to show a table in descending order by count? Currently it always goes alphabetically.

Now:

Anthony        6
Brian          8
Michael        4

I would like to see:

Brian          8
Anthony        6
Michael        4

The way I'm currently outputting this is ` | stats count by login_name, year_day | stats count AS "Number of days Logged in" by login_name

[vasanthmss]

use the below one,

| sort 0 - "Number of days Logged in"

while using sort you can mention the limitation, zero means there will not be any limits applied. 😉

[richgalloway · Accepted solution]

Maybe ' ... | sort - "Number of days Logged in"' ?

[w531t4]

I downvoted this post because does not work on datasets larger than 10000 rows

[helge]

Add limit=0 to remove the limitation to 10,000 rows

[bcusick]

BeautifuL! Thank you.