How to auto-range with a descending percent manner

[wait4amigo]

For example, I want my data is ranged as:

Value Percent
Larger than 0 100%
Larger than 5 95%
Larger than 10 91%
...
Larger than 85 15%
Larger than 90 8%
...

Since the range will be divided to many spans, I don't want to create span manually (through rangemap or case), instead I want to use "bucket span=" to auto-divide the range, not sure if we can achieve this or not...

[MuS · Accepted solution]

Hi wait4amigo,

you can use bucket Value span=5 which will set Value into a discrete set. The resulting values for Value will look like this 0-5 or 5-10 but it should work.

hope this helps ...

cheers, MuS

[MuS]

Well, you asked for auto-divide range and this is done with bucket.
The "0-5, 0-10, 0-15..." or "0-100, 0-95, 0-90..." examples could be solved with rangemap, but you have to assign the ranges manually.
The "larger as.." examples could be solved with eval but again it must be defined manually or at least with some fancy math magic.

[wait4amigo]

Thanks for your answer, but my question is not only for "discrete set", I want the resulting values to be "0-5, 0-10, 0-15..." or "0-100, 0-95, 0-90..."