How to use the bin command?

[amarish_vlabs]

Hi Team,

I have a field which takes values from 1 to 100. So I want use the bin command in such a way so the output should be like 1-10, 11-20, 21-30, 31-40 ..............99-100

Output:

1-10            13
11-20            9
21-30           21
31-40            5
................................
................................
................................

91-100           3

Please suggest

Thanks in advance,
Amarish

[diogofgm · Accepted solution]

Use this:
| bin field_name bins=10 | stats count by field_name

More information on bins from docs here (check the Example 2 in docs).

[jeffland]

Actually, using bins=10 will produce ten bins, so if your range is from 0 to 1000, your first bin will be 0-100, the next 100-200 and so on - use span=10 to have bins with a length of 10 each, no matter your range.

[amarish_vlabs]

Thank you so much for your reply. I have used your query and got the output like 0-10 , 10-20, 20-30.....etc. But I want to see the out put like 0-10 , 11-20, 21-30 , 31-40 .......etc. Please let me know Is this possible ?

Thanks,
Amarish