topic Re: Manually defining bucket range in Deployment Architecture

Manually defining bucket range

aaronkorn — Mon, 15 Apr 2013 20:27:41 GMT

Is there a way to manually define the range of a bucket for a search? For example we would want a bucket for 0-7, 8-15 etc...

Thanks!

Re: Manually defining bucket range

BenjaminWyatt — Mon, 15 Apr 2013 21:10:09 GMT

I'm not entirely sure what you're asking. You can set the bucket width quite easily as follows:

MySearchTerms | bucket MyField span=foo

Is this what you are looking to do? It appears to match the criteria you have given above, but I didn't know if you were looking to do something complex (for example, make buckets of different sizes, such as 0-10,10-30,30-60, etc.)

Re: Manually defining bucket range

aaronkorn — Mon, 15 Apr 2013 21:26:39 GMT

Yes I am looking to make buckets of different sizes.

Re: Manually defining bucket range

gkanapathy — Mon, 15 Apr 2013 21:38:57 GMT

You can simply use the eval command's case() function, e.g., ... | eval case(0<=myfield<8,0, 8<=myfield<15, 8, 15<=myfield<100, 15, 100<=myfield,100)

Re: Manually defining bucket range

BobM — Tue, 16 Apr 2013 08:31:06 GMT

It may be simpler to use the rangemap command to do this. e.g. The following will set the value range to 1 if the count is between 1 and 100, 2 if it is between 101 and 110, 3 if between 111 and 700, 4 if it is over 700.

* | stats count by host | rangemap field=count 1=1-100 2=101-110 3=111-700 default=4

Re: Manually defining bucket range

BobM — Tue, 16 Apr 2013 10:23:52 GMT

you can also use this with string bucket such as

| rangemap field=number tiny=0-1 small=1-10 medium=10-100 large=100-10000 default=enormous